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

171 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
squirms1837634(None) 
squires163812841squires
squirm17387671squirm_
squirmy21374291squirmy
squirts16348011squirts
esquires17266212esquires
quires154015752_quires
quirks19419112_quirks
quirts154213552_quirts
squares163714462squares
squarks20417182squarks
squibs17317452squi_bs
squids16409802squi_ds
squills1666312squills
squints16339032squints
squire155912462squir_e
squired173710062squired
squirish2045112squirish
squirmed2034172squirmed
squirmer1934372squirmer
squirmers2053112squirmers
squirt153812932squir_t
acquires1945403acquires
affirms1534383affirms
chirms135113983_chirms
enquires17276973enquires
equids16439143equi_ds
equines161811593equines
equips17387193equi_ps
equites162212493equites
esquire16376603esquir_e
esquired18315083esquired
faquirs1943863faquir_s
firms105217423__firms
guiros7389093_guiros
infirms1245563infirms
inquires17237363inquires
qualms17317243_qualms
quarks193810913_quarks
quarts154715933_quarts
querns15307943_querns
quicks21389303_quicks
quids154917463_qui_ds
quiets154014373_quiets
quiffs21135433_quiffs
quills153811853_quills
quilts154112543_quilts
quins144819853_qui_ns
quints154316563_quints
quips164713373_qui_ps
quipus17458003_quipus
quire144917133_quir_e
quired163711953_quired
quirk184011003_quir_k
quirky22435533_quirky
quirt144624233_quir_t
quits144122353_qui_ts
quorums1843893_quorums
requiems1943253requiems
requires17168703requires
sabirs85414633sabir_s
sadisms10359113sadisms
satires72617573satires
sauries72821623sauries
schisms1437173schisms
scrims104615933scri_ms
scums95017423scu__ms
scurfs113210813scu_rfs
seisms84912143s_eisms
sequins1637863sequi_ns
sexisms16226223sexisms
shairds11216263shairds
shairns10276783shairns
shims104422553s_hi_ms
shires95225573s_hires
shirks134814123s_hirks
shirrs94413173s_hirrs
shirts94918343s_hirts
sims65737173s__i_ms
sires55945373s__ires
sirs44338333s__ir_s
skims114517193s_ki_ms
skirls10449823s_kirls
skirrs10448193s_kirrs
skirts104111503s_kirts
slims75423653s_li_ms
sluices959073sluices
slumisms1244723slumisms
slums74623433slu__ms
slurbs8439743slu_rbs
slurps84410003slu_rps
slurs54123373slu_r_s
smarms105712533s_marms
smirks124910123s_mirks
sodiums10177213sodiums
souaris7312333souaris
sours55230503sou_r_s
speirs85013233speir_s
sperms102512603s_perms
spirems11499563s_pirems
spires84628113s_pires
spirts85317133s_pirts
spurns84811383spu_rns
spurs74621523spu_r_s
spurts84814973spu_rts
squabs17429323squ_abs
squads164410293squ_ads
squalls1647313squalls
squama1736533squ_ama
square154513363squar_e
squared173610563squared
squarer163410663squarer
squarers17338023squarers
squarest17338223squarest
squarish2047323squarish
squark19438113squar_k
squats153712963squ_ats
squawks23294883squawks
squaws18438783squ_aws
squeaks2034523squeaks
squeals1636513squeals
squegs1675643squ_egs
squib163710503squi__b
squid154211903squi__d
squiffy2542573squiffy
squill1537233squi_ll
squilla1635533squilla
squillas1745333squillas
squinch2134833squinch
squinny19274223squinny
squint154214793squi_nt
squinty19287063squinty
squireen1744393squireen
squireens1842733squireens
squiring18177563squiring
squirmier2042853squirmier
squirmiest2142793squirmiest
squirming2143223squirming
squirrel17414533squirrel
squirrels18333423squirrels
squirted1845793squirted
squirter1746523squirter
squirters1835073squirters
squish1838573squi_sh
squishes20198393squishes
squishy2244023squishy
stairs65416333stair_s
stirks104914243s_tirks
stirps85011823s_tirps
stirs55921623s_tir_s
storms85814633s_torms
stums75320083stu__ms
sturts63915143stu_rts
sucres84218893s_ucres
suers55128483s_uer_s
suints64617783s_uints
suites63727403s_uites
suits55028053s_ui_ts
sums65837583s_u__ms
suras55336333s_u_ras
surds65624663s_u_rds
surfs85022543s_u_rfs
surimi839103s_urimi
surimis938843s_urimis
surras65919533s_urras
sutras64818593s_utras
swarms116112173s_warms
swims105514143s_wi_ms
swirls94010133s_wirls
thairms1244453thairms
truisms9106823truisms

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271716.59320328.7
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.07925242.4
 
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.