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

174 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
squatted183534(None) 
squatter1735911squatter
equated171910402equa_ted
quanted1738962_quanted
quitted17339892_quitted
scatted103512772s_catted
slatted84015182s_latted
smutted1037462smu_tted
spatted104014142s_patted
splatted11356742splatted
squadded2033842squadded
squalled1835942squalled
squared173610562squa_red
squashed21215982squashed
squattered2043252squattered
squatters1834942squatters
squattest1844612squattest
squattier1843712squattier
squatty1964822squatt_y
squawked2543012squawked
squinted1847062squinted
squirted1845792squirted
swatted114110692s_watted
abutted1056983abu_tted
acquitted2143503acquitted
aquatinted2072203aquatinted
batted95623653__batted
blatted104812713_blatted
butted94722063_bu_tted
catted95422473__catted
chatted133411893_chatted
coquetted2154823coquetted
defatted1335673defatted
deratted1048403deratted
dratted9358593_dratted
duetted937023_duetted
equaled17166923equa_led
equalled1834863equalled
equate152012463equa_te_
equates162012323equa_tes
fatted105419843__fatted
flatted114012943_flatted
glutted937243glu_tted
gutted84716363_gu_tted
hatted104921513__hatted
hutted104616333_hu_tted
jutted144315023_ju_tted
liquated1835493liqua_ted
matted94521413__matted
mutated102712253_mutated
nutated83113423_nutated
nutted74316973_nu_tted
patted94724683__patted
platted103614263_platted
putted94220253_pu_tted
quacked2336793_quacked
quadded1934863_quadded
quaffed2334253_quaffed
quailed1737823_quailed
quaked203910033_qua_ked
quarte154115323_quarte_
quarter163211853_quarter
quartes163314933_quartes
quartet162814893_quartet
quashed20207973_quashed
quate144521413_qua_te_
quatre153512353_quatre_
quatres163411933_quatres
quested17168383_quested
quieted17309723_quieted
quilted17319313_quilted
quirted17369213_quirted
quitter162910753_quitter
quoited1756403_quoited
quoted16359453_qu_oted
ratted74923343__ratted
rutted74518403_ru_tted
salted74121203s__alted
sated66238533s__a_ted
sauted74119603s__auted
sauteed8349613sau_teed
scanted104114393s_canted
scarted104816123s_carted
scathed134012643s_cathed
scatter93815173s_catter
sculpted1354883sculpted
scutate9310323scutate_
scutter93512173scu_tter
scuttled1134533scuttled
seated75131053s_ea_ted
sedated93714343seda_ted
shafted14288813s_hafted
shatter103615703s_hatter
sheathed1547223sheathed
shitted114212053s_hitted
shotted113912403s_hotted
shunted11339783shu_nted
shuted103913173shu__ted
shutter103712143shu_tter
shuttled1234673shuttled
sinuated938413sinua_ted
situated938033situa_ted
skated114414883s_ka_ted
slanted83514743s_lanted
slated75028313s_la_ted
slitted83513313s_litted
slotted84613883s_lotted
smarted105012613s_marted
smatter93613333s_matter
solated83618023sola_ted
sotted74121403s__otted
southed114313993sou_thed
spathed134013183s_pathed
spatter94016523s_patter
spitted103912703s_pitted
splatter10348883splatter
spotted103713143s_potted
sprattled1263313sprattled
spurted103111973spu_rted
sputter94014053spu_tter
squabbled2342563squabbled
squad155110793squa___d
squalid1737053squa_lid
squaller1736083squaller
squamae1845723squamae_
squamate1945783squamate_
squamates2045593squamates
squander1835533squander
square154513363squa_re_
squarer163410663squa_rer
squares163714463squa_res
squasher20185783squasher
squashes20207803squashes
squat143720143squa_t__
squatly1946433squa_tly
squatness1844943squatness
squats153712963squa_t_s
squattiest1944233squattiest
squattily2142653squattily
squatting1934513squatting
squawker2443093squawker
squeaked2283903squeaked
squealed1885353squealed
squeezed2743253squeezed
squegged2042893squegged
squibbed2283423squibbed
squidded2043723squidded
squiffed2433733squiffed
squinter1747363squinter
squired173710063squ_ired
squirmed2034173squirmed
squirter1746523squirter
squished21186393squished
squushed21193703squushed
started84217323s_tarted
stated75427833s_ta_ted
statued8459893s_tatued
stetted82610403s_tetted
stotted83511423s_totted
strutted946343strutted
stunted83010403stu_nted
stutter72911463stu_tter
suited74019423s_u_ited
suttee63721543s_u_ttee
swathed144611933s_wathed
swatter104113323s_watter
sweated113411543swea_ted
swotted11398713s_wotted
tatted74920533__tatted
truanted935373truanted
tutted75117443_tu_tted
unhatted1238183unhatted
unmatted1138293unmatted
vatted104214733__vatted

Search took 7 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621746.62622058.9
3Display Results1741740.0632761.9
 (SQL Overall)1786911746.85926052.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.