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 “roust” with Change Limit: [1] [2]

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

135 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
roust5553206(None) 
joust125122291joust
oust46747441_oust
roast56230141roast
robust8310431robust
roost55730931roost
rouse56634701rouse
rousts617016721rousts
rout46153281rou_t
routs57133411routs
rust45544911r_ust
adust64117452adust
arouse65019982arouse
boast75935702boast
boost75132472boost
bouse75931852bouse
bousy104917842bousy
bout66353292bou_t
bouts75131312bouts
bust65947782_bust
coast75236272coast
cost68057942co_st
count74932052count
court75532772court
crouse84619362crouse
crust75827662crust
doest65829522doest
dost57248352do_st
doubt8720092doubt
douse66329722douse
dust57142532_dust
foist85730972foist
fount84727032fount
frost84727832fro_st
frowst125512072frowst
gout56646002gou_t
gouts64826172gouts
grouse74315022grouse
grout65330422grou_t
grouts75015612grouts
gust55240702_gust
hoist86433212hoist
horst85833512horst
host77852832ho_st
house89131422house
joist125125652joist
jousts135011272jousts
just115433342_just
locust85312342locust
lost47951492lo_st
louse56131012louse
lousy84617082lousy
lout45952142lou_t
louts56330272louts
lust47442602_lust
moist76033582moist
most66554202mo_st
moult74728722moult
mount74128062mount
mouse77133002mouse
mousy106716942mousy
must65145442_must
nous46136982nous_
oast47156322_oast
ousts55225702_ousts
out38072152_ou_t
outs45746962_outs
post67953362po_st
poult76928872poult
pout65752552pou_t
pouts75530322pouts
prost75434102pro_st
reest54938092reest
rest46459842r_est
reuse56025362reuse
rhus75114052rhus_
roasts64915412roasts
robot7325972robot
robs65837872robs_
robusta944282robusta
rocs65533662rocs_
rods56442062rods_
roes45954142roes_
roms67038962roms_
roose56127092roose
roosts64916322roosts
root45655922ro_ot
roots55933672roots
roquet154415892roquet
rose46148902ro_se
roset55945242roset
rosy76024872ro_sy
rot37282952ro__t
rots46454092rots_
roue45941742rou_e
rouen54920902rouen
roues56039352roues
rouge65423442rouge
rough97819432rough
round64318432round
roup66627692rou_p
roupet84218342roupet
roups75118902roups
roupy106112712roupy
roused75426442roused
rouser65224082rouser
rouses65436282rouses
rousted84013322rousted
rouster73517082rouster
route55132072route
routh86423072routh
roux117419362rou_x
rows75941752rows_
runt46647982r_unt
ruse45938932r_use
rush76628182r_ush
rusk85823312r_usk
rusts55026992r_usts
rusty85221052r_usty
rut35560522r_u_t
ruts44541492r_uts
sous46947212sous_
souse56530772souse
toast55831012toast
tost48351922to_st
touse55430672touse
tout46753822tou_t
touts54830392touts
trout57332572trou_t
trouts66116632trouts
trust55426852trust
worst86330132worst
wost76544362wo_st
yous76230652yous_
youse85322232youse

Search took 4 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 Filter178691538000.190940478.9
2DLD Change Limit538001352.93618324.3
3Display Results1351350.0304500.0
 (SQL Overall)1786911353.15656619.5
 
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.