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

186 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
squatter173591(None) 
squatted1835341squatted
squatters1834951squatters
squattier1843711squattier
quarter163211862_quarter
quitter162910752_quitter
scatter93815172s_catter
scutter93512172scu_tter
shatter103615702s_hatter
shutter103712142shu_tter
smatter93613332s_matter
spatter94016522s_patter
splatter10348882splatter
sputter94014052spu_tter
squaller1736082squaller
squander1835532squander
squarer163410662squa_rer
squasher20185782squasher
squattered2043262squattered
squattest1844612squattest
squatty1964822squatt_y
squawker2443092squawker
squinter1747362squinter
squirter1746522squirter
stutter72911462stu_tter
swatter104113322s_watter
abutter957513abu_tter
acquitter2043553acquitter
aquatinter1982083aquatinter
batter84928883__batter
betatter1035453betatter
blatter94415653_blatter
butter84724233_bu_tter
chatter124416643_chatter
clatter94014973_clatter
clutter94211663clu_tter
cutter84521003_cu_tter
equate152012463equa_te_
equated171910403equa_ted
equates162012323equa_tes
equator1637483equa_tor
fatter94523213__fatter
flatter103815963_flatter
flutter104012093flu_tter
gutter73817713_gu_tter
hatter94724873__hatter
latter65027893__latter
matter84325343__matter
mutter84418883_mu_tter
natter64420743__natter
nutter63918053_nu_tter
patter84628263__patter
phatter123810203_phatter
platter93917413_platter
putter83921443_pu_tter
quaffer2235133_quaffer
quainter1765903_quainter
quaker193811623_qua_ker
quakier20239203_quakier
quanted1738973_quanted
quarte154115333_quarte_
quartern17286483_quartern
quarters173110463_quarters
quartes163314943_quartes
quartet162814903_quartet
quartier1737553_quartier
quasher19198623_quasher
quate144521413_qua_te_
quatre153512363_quatre_
quatres163411943_quatres
quaver18309313_qua_ver
quester161410023_quester
quieter162810333_quieter
quilter16279803_quilter
quitted17339893_quitted
quitters17238533_quitters
quittor16285603_quittor
quoter153510093_qu_oter
ratter64326313__ratter
reutter71010093reu_tter
salter64325083s__alter
saunter72913453sau_nter
scanter94215183s_canter
scatted103512773s_catted
scatters103612753s_catters
scattier10267583s_cattier
scutate9310323scutate_
scutters103311023scu_tters
seater64534163s_ea_ter
sedater83713633seda_ter
sequester1844443sequester
setter64023723s__etter
shatters113313913s_hatters
sheather1458233sheather
shunter103611733shu_nter
shutters113611353shu_tters
shuttler1164903shuttler
sitter63323383s__itter
skater105015493s_ka_ter
skitter113810403s_kitter
slater64429183s_la_ter
slather103816083s_lather
slatier74016813s_latier
slatted84015183s_latted
slattern837093s_lattern
slitter73615873s_litter
slotter73314453s_lotter
sluttier836453sluttier
smarter94113133s_marter
smatters104011713s_matters
smutted1037463smu_tted
smuttier1035213smuttier
souter64225923sou__ter
souther104116303sou_ther
spatted104014143s_patted
spatters103914703s_patters
spitter94015183s_pitter
splatted11356743splatted
splatters11327543splatters
splitter10348443splitter
splutter10357443splutter
spotter94514883s_potter
spurter94013003spu_rter
sputters104012873spu_tters
sputtery13366473spu_ttery
squabbier2242753squabbier
squabbler2242733squabbler
squadded2033843squadded
squalider1943843squalider
squalled1835943squalled
squallers1834683squallers
squallier1844363squallier
squalor1644423squa_lor
squamae1845723squamae_
squamate1945783squamate_
squamates2045593squamates
squanders1934443squanders
square154513363squa_re_
squared173610563squa_red
squarers17338033squa_rers
squares163714463squa_res
squashed21215983squashed
squashers21184983squashers
squashes20207803squashes
squashier2143913squashier
squat143720143squa_t__
squatly1946433squa_tly
squatness1844943squatness
squats153712963squa_t_s
squattering2143803squattering
squattiest1944243squattiest
squattily2142653squattily
squatting1934513squatting
squawked2543013squawked
squawkers2542483squawkers
squeaker2184883squeaker
squeakier2242903squeakier
squealer17115603squealer
squeezer2643373squeezer
squinted1847063squinted
squinters1835523squinters
squintier1844473squintier
squirmer1934373squirmer
squirted1845793squirted
squirters1835083squirters
starter73817883s_tarter
stater64427563s_ta_ter
straiter8311783straiter
strutter846503strutter
stutters83210473stu_tters
suaver93014233s_ua_ver
subtler92910853s_ubtler
suiter64121813s_u_iter
sumpter1138873s_umpter
sutler63718393s_u_tler
suttee63721543s_u_ttee
swather134213603s_wather
swatted114110693s_watted
swatters113911793s_watters
sweater103712723swea_ter
sweatier1147033sweatier
swotter10399473s_wotter
tatter64024573__tatter
utter54218763__u_tter
watter93221983__watter
yatter94116213__yatter

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621867.23320207.7
3Display Results1861860.0762447.4
 (SQL Overall)1786911867.71523161.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.