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

206 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
squirm1738767(None) 
squire155912461squire
squirms18376341squirms
squirmy21374291squirmy
squirt153812931squirt
esquire16376602esquire
quire144917132_quire
quirk184011002_quirk
quirt144624232_quirt
square154513362square
squark19438112squark
squib163710502squi_b
squibs17317452squibs
squid154211902squi_d
squids16409802squids
squill1537232squill
squint154214792squint
squired173710062squired
squires163812842squires
squirmed2034172squirmed
squirmer1934372squirmer
squirts16348012squirts
squish1838572squish
acquire1835603acquire
affirm1435523affirm
asquint16208323asquint
chirm125317063_chirm
enquire16287213enquire
enquiry19254043enquiry
equid154610323equi_d
equids16439143equids
equine151711573equine
equip16467263equi_p
equips17387193equips
equity1838103equity
esquired18315083esquired
esquires17266213esquires
faquir1834313faquir_
faquirs1943863faquirs
firm96026463__firm
guiro63712093_guiro
infirm1137043infirm
inquire16227993inquire
inquiry19254703inquiry
qualm163511183_qualm
quare143920543_quare
quark184614123_quark
quart144027853_quart
quern143610403_quern
query174212083_query
quick204311063_quick
quid144922363_qui_d
quids154917473_quids
quiet144530733_quiet
quiff201111563_quiff
quill148413773_quill
quilt144125103_quilt
quin135823923_qui_n
quins144819853_quins
quint144529903_quint
quip154818623_qui_p
quips164713373_quips
quipu164811643_quipu
quired163711953_quired
quires154015753_quires
quirks19419113_quirks
quirky22435533_quirky
quirts154213553_quirts
quit136136513_qui_t
quite144621463_quite
quits144122353_quits
quiz224920003_qui_z
quorum1736023_quorum
requiem1836113requiem
require16148653require
sabir75917003sabir_
sabirs85414633sabirs
sadism94113493sadism
satire63218003satire
saury84317223sau_ry
schism1338173schism
scrim95419743scri_m
scum85924523scu__m
scurf104719323scu_rf
scurry11419593scurry
scutum1036373scutum
seism75019023s_eism
sequin1538523sequi_n
sequins1637863sequins
sexism15227653sexism
shaird10288703shaird
shairn9269063shairn
shim95827863s_hi_m
shire84727133s_hire
shirk124817843s_hirk
shirr84716923s_hirr
shirt84533903s_hirt
sim56553153s__i_m
sir35746683s__ir_
sire46150423s__ire
sirs44338343s__irs
skim105322523s_ki_m
skirl96012923s_kirl
skirr94810553s_kirr
skirt95624673s_kirt
slim66631963s_li_m
sluice849513sluice
sluicy1166483sluicy
sluing74315883sluing
slum65430513slu__m
slumism1136513slumism
slur45525153slu_r_
slurb74116323slu_rb
slurp74014983slu_rp
slurry9378603slurry
slurs54123373slu_rs
smarm95517603s_marm
smirk116612753s_mirk
sodium92111453sodium
souari6311383souari
sour45935893sou_r_
sours55230503sou_rs
speir75315363speir_
speirs85013233speirs
sperm93216023s_perm
spire75828693s_pire
spirem104214163s_pirem
spirt75032953s_pirt
spiry105017353s_piry
spuing94313363spuing
spur65321193spu_r_
spurn74815453spu_rn
spurry11429123spurry
spurs74621523spu_rs
spurt77227983spu_rt
sputum1035943sputum
squab163810733squ_ab
squabs17429323squabs
squad155110793squ_ad
squads164410293squads
squall1538003squall
squama1736533squama
squared173610563squared
squarer163410663squarer
squares163714463squares
squarks20417183squarks
squash1846833squash
squat143720143squ_at
squats153712963squats
squaw17368983squ_aw
squawk22385373squawk
squaws18438783squaws
squeak1935253squeak
squeal1538023squeal
squeg1588033squ_eg
squegs1675643squegs
squiffy2542573squiffy
squilla1635533squilla
squills1666313squills
squinch2134833squinch
squinny19274223squinny
squints16339033squints
squinty19287063squinty
squireen1744393squireen
squiring18177563squiring
squirish2045113squirish
squirmers2053113squirmers
squirmier2042853squirmier
squirming2143223squirming
squirrel17414533squirrel
squirted1845793squirted
squirter1746523squirter
squishy2244023squishy
squush1833993squush
stair54719943stair_
stairs65416333stairs
stir45723253s_tir_
stirk95717413s_tirk
stirp76815503s_tirp
stirs55921623s_tirs
storm76520403s_torm
stum65526023stu__m
sturt56028963stu_rt
sucre75019103s_ucre
suer45334033s_uer_
suers55128483s_uers
suing65026363s_uing
suint55638183s_uint
suit45649873s_ui_t
suite54829563s_uite
suits55028053s_uits
sum56346013s_u__m
supra73614253s_upra
sura45740293s_u_ra
surd56433813s_u_rd
sure45447413s_u_re
surf76039313s_u_rf
surimi839103s_urimi
surra55521343s_urra
sutra54217933s_utra
swarm106218843s_warm
swim96221403s_wi_m
swirl84514143s_wirl
swum96416823swu__m
thairm1156963thairm
truism8118623truism

Search took 6 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 Filter1786911127160.360496363.9
2DLD Change Limit1127162065.36021029.1
3Display Results2062060.0603433.3
 (SQL Overall)1786912065.78030915.4
 
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.