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 “phuts” 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.

124 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
phuts10461350(None) 
bhuts105812951bhuts
huts76737441_huts
phots105418501phots
phut96925971phut_
pouts75530321pouts
puts65641751p_uts
shuts85622481shuts
abuts75417072abuts
bhut95425712bhut_
bouts75131312bouts
bruts75922952bruts
buts67247692_buts
chats105730092chats
chits105424572chits
chubs125412622chubs
chugs115511942chugs
chums125015832chums
chute104316462chute
chutes114615772chutes
cuts65841152_cuts
dauts67822242dauts
dhuti937542dhuti
dhutis1035942dhutis
ghats95818612ghats
ghauts10447782ghauts
gluts66120132gluts
gouts64826172gouts
guts56637252_guts
hats76858252_hats
hets75547202_hets
hits75545132_hits
hots78349332_hots
hubs96027142_hubs
hues75235232_hues
hugs86129752_hugs
hums96831422_hums
huns76136932_huns
hunts86826172_hunts
hurts86922822_hurts
hut66457292_hut_
juts115930162_juts
khats125316012khats
khets124913432khets
louts56330272louts
mauts75927192mauts
muts64839982_muts
nuts45032672_nuts
outs45746962_outs
pacts95125802pacts
pants76536922pants
parts77743372parts
pasts75936502pasts
pats66460852p_ats
peats76140192peats
pelts76128812pelts
pests75933272pests
pets66248332p_ets
phat95837862phat_
phis95724902ph_is
phons105221142phons
phot95534362phot_
photo104417232photo
photos113316642photos
pht86030522ph_t_
pints75936222pints
pits66348742p_its
plats75531372plats
plots75025672plots
plugs85213492plugs
plums94619952plums
plus66324832plu_s
poets76024442poets
ports75934592ports
posts75228782posts
pots66452362p_ots
poufs105616062poufs
poults84613482poults
pours74623182pours
pout65752552pout_
pouty107018812pouty
prats76333392prats
pruta7314242pruta
pubs85029212p_ubs
puds75630512p_uds
pugs76332772p_ugs
puls65437562p_uls
puns66641482p_uns
punts75828002punts
pups86032232p_ups
purs65641042p_urs
pus55547842p_u_s
puss64830132p_uss
put55759072p_ut_
putt66937842p_utt
putts75719272putts
putz158326322p_utz
rhus75114052rhu_s
routs57133412routs
ruts44541492_ruts
scuts74522522scuts
shits84731172shits
shots84730852shots
shouts94017722shouts
shuls85319712shuls
shuns85018142shuns
shunts95712022shunts
shut76137592shut_
shute84520352shute
shutes93518222shutes
sluts54523982sluts
smuts75415712smuts
spouts85115112spouts
tauts56125512tauts
thuds95110132thuds
thugs95611992thugs
thus76721472thu_s
touts54830392touts
tuts45838452_tuts
uts35534372__uts
whats117718992whats
whets115019612whets
whits115923822whits
whups134210002whups

Search took 2 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.300595636.7
2DLD Change Limit538001241.54634799.5
3Display Results1241240.0304133.3
 (SQL Overall)1786911241.87695251.1
 
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.