Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “beshout” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

110 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
beshout1231184(None) 
beshouts1346761beshouts
bescour1145202bescour
beshouted1544072beshouted
beshroud1443802beshroud
besmut10310652bes_mut
besot76429712bes_o_t
reshoot102513892reshoot
reshot93519632resho_t
shout85433172__shout
washout13410132washout
backout15612953backout
bailout9414133bailout
bashful1556553bashful
beaut75135213be__aut
becloud1246293becloud
bedpost1247243bedpost
bedsheet1446683bedsheet
beechnut1543803beechnut
befoul1137253be_foul
begot84625953be_go_t
behest11314613be_hest
behold1247343be_hold
behoof1458683be_hoof
behove14207203be_hove
behowl1445533be_howl
beknot1239763bekno_t
bescours1245093bescours
beset76739133bes__et
beshame1447483beshame
beshouting1644023beshouting
beshrew1554393beshrew
beshrouds1543063beshrouds
besmoke15416623besmoke
besmooth1543353besmooth
besmuts1134683bes_muts
besnow1145713besno_w
besnows1245153besnows
besom95716973bes_o_m
besoms105712733bes_oms
besots86415453bes_ots
besought1454003bes_ought
bespoke15468113bespoke
bespouse1245113bespouse
best66355323bes___t
bestow1149463besto_w
bestows1248863bestows
bestud9439303bes_tud
bethorn1238643bethorn
bethought1853443bethought
bhoot104322103b__hoot
bhut95425713b__h_ut
bishop1336943bisho_p
bishops1437033bishops
bistort91216523bistort
blowout1248403blowout
bout66353293b___out
bowshot1578253bowsho_t
breakout1456283breakout
bugout9311863b_ugout
burgout1049773burgout
burnout9310453burnout
bushgoat1443443bushgoat
bushtit1245963bushtit
buyout11310103b_uyout
dehort104618103de_hort
despot93413293despo_t
devout10712993de_vout
eelpout947783eelpout
escort84616483_escort
escot75320083_esco_t
exhort16410803_exhort
eyeshot1386553eyesho_t
kashrut1444913kashrut
mahout11415813_mahout
missout9412663missout
outshout1149493outshout
readout8615513readout
redout71820253re_dout
reshod103012233resho_d
reshoe92816483resho_e
reshoed112212153reshoed
reshoes102316033reshoes
reshone102414163reshone
reshoots11228413reshoots
reshow123111433resho_w
reshown13257903reshown
reshows132510453reshows
resort65728623res_ort
respot83117633respo_t
resprout1078783resprout
scout75031453__scout
seascout1047953seascout
sellout7313583sellout
setout64719473se_tout
shoat85633953__shoat
shoot84235913__shoot
short85040533__short
shot76150263__sho_t
shott85332193__shott
shouts94017723__shouts
shut76137593__sh_ut
snout54530633__snout
spout75029633__spout
stout57434053__stout
unshut939013unsh_ut
upshoot1256693upshoot
upshot1138453upsho_t
washouts1445903washouts
without1348893without

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit1340271106.80019709.9
3Display Results1101100.0303666.7
 (SQL Overall)1786911107.23324705.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.