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

139 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
squatters183494(None) 
squatter1735911squatter_
quarters173110452_quarters
quitters17238522_quitters
scatters103612752s_catters
scutters103311022scu_tters
shatters113313912s_hatters
shutters113611352shu_tters
smatters104011712s_matters
spatters103914702s_patters
splatters11327542splatters
sputters104012872spu_tters
squallers1834682squallers
squanders1934442squanders
squarers17338022squa_rers
squashers21184982squashers
squatness1844942squatness
squatted1835342squatte_d
squattered2043252squattered
squattest1844612squattest
squattier1843712squattier_
squawkers2542482squawkers
squinters1835522squinters
squirters1835072squirters
stutters83210472stu_tters
swatters113911792s_watters
abutters1056993abu_tters
acquitters2142953acquitters
aquatinters2081643aquatinters
batters94626023__batters
betatters1134963betatters
blatters104414093_blatters
butters94521723_bu_tters
chatters134213953_chatters
clatters103313913_clatters
clutters103210353clu_tters
cutters94218963_cu_tters
equates162012323equa_te_s
equators1737473equa_tors
flatters113814203_flatters
flutters114010823flu_tters
gutters83715513_gu_tters
hatters104221523__hatters
matters94421753__matters
mutters94117143_mu_tters
natters73718063__natters
nutters74215433_nu_tters
patters94825193__patters
platters103415283_platters
putters94219193_pu_tters
quaffers2333963_quaffers
quakers20309693_qua_kers
quarter163211853_quarter_
quartern17286473_quartern
quarterns18285153_quarterns
quartes163314933_quarte_s
quartets17277573_quartets
quartiers1845183_quartiers
quashers20186803_quashers
quatres163411933_quatre_s
quavers19309013_qua_vers
questers17168763_questers
quieters17248733_quieters
quilters17228433_quilters
quitter162910753_quitter_
quittors17155413_quittors
quoters16369263_qu_oters
ratters74422473__ratters
reutters8138573reu_tters
salters73622253s__alters
saunters82911753sau_nters
scatter93815173s_catter_
scutter93512173scu_tter_
seaters74028943s_ea_ters
sequesters1943843sequesters
setters73822063s__etters
shatter103615703s_hatter_
sheathers1557553sheathers
shunters113210753shu_nters
shutter103712143shu_tter_
shuttlers1254123shuttlers
sitters74221553s__itters
skaters113512963s_ka_ters
skitters12349553s_kitters
slaters73123733s_la_ters
slathers113914783s_lathers
slattern837093s_lattern
slatterns935363s_latterns
slitters84014133s_litters
slotters84012403s_lotters
smatter93613333s_matter_
souters74422603sou__ters
southers114214453sou_thers
spatter94016523s_patter_
spitters104113383s_pitters
splatter10348883splatter_
splitters11307323splitters
splutters11286273splutters
spotters104313383s_potters
spurters103311703spu_rters
sputter94014053spu_tter_
sputtery13366473spu_ttery
squabblers2341843squabblers
squaller1736083squaller_
squalors1744583squa_lors
squamates2045593squamate_s
squander1835533squander_
squarer163410663squa_rer_
squares163714463squa_re_s
squasher20185783squasher_
squashes20207803squashe_s
squats153712963squa_t__s
squattering2143803squattering
squattiest1944243squattiest
squattily2142653squattily
squatting1934513squatting
squatty1964823squatt__y
squawker2443093squawker_
squeakers2284113squeakers
squealers1894453squealers
squeezers2742553squeezers
squinter1747363squinter_
squirmers2053113squirmers
squirter1746523squirter_
starters83714773s_tarters
staters73922343s_ta_ters
strutters955703strutters
stutter72911463stu_tter_
suiters73618883s_u_iters
sumpters1238023s_umpters
sutlers73116973s_u_tlers
suttees74114063s_u_ttees
swathers144512083s_wathers
swatter104113323s_watter_
sweaters113811063swea_ters
swotters11448483s_wotters
tatters74520483__tatters
utters63817123__u_tters
yatters103914623__yatters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411396.93621430.4
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.42224075.9
 
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.