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

114 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
squirmed203417(None) 
squired173710061squir_ed
squirmer1934371squirmer
squirted1845791squirted
esquired18315082esquir_ed
quired163711952_quir_ed
quirked21325432_quirked
quirted17369212_quirted
squared173610562squar_ed
squibbed2283422squibbed
squidded2043722squidded
squiffed2433732squiffed
squinted1847062squinted
squire155912462squir_e_
squireen1744392squireen
squires163812842squir_es
squirm17387672squirm__
squirmers2053112squirmers
squirmier2042852squirmier
squirms18376342squirm_s
squirmy21374292squirm_y
squirrel17414532squirrel
squirter1746522squirter
squished21186392squished
acquired2044043acquir_ed
affirmed1743213affirmed
chirmed15379733_chirmed
enquired18255793enquir_ed
equipped2243073equipped
esquire16376603esquir_e_
esquires17266213esquir_es
firmed125411883__firmed
infirmed14205343infirmed
inquired18245933inquir_ed
queried1738683_queried
quieted17309723_quieted
quilled17329283_quilled
quilted17319313_quilted
quipped2175163_quipped
quire144917133_quir_e_
quires154015753_quir_es
quitted17339893_quitted
quizzed2534043_quizzed
required18156833requir_ed
scummed14347913scu_mmed
scurried11267053scurried
sequined18105653sequi_ned
sequinned1982413sequinned
shimmed15338583s_himmed
shirked153710463s_hirked
shirred113710503s_hirred
sired66134283s__ir_ed
skimmed16306053s_kimmed
skirled12348183s_kirled
skirred12347083s_kirred
skirted12388613s_kirted
slimed94915123s_li_med
slimmed12368473s_limmed
sluiced1046053slui_ced
slummed12359273slu_mmed
slurped10368753slu_rped
slurred8359193slu_rred
slurried9285943slurried
smirked14307233s_mirked
sourced1038453sou_rced
soured74921863sou_r_ed
speired103811103speir_ed
spired94921863s_pir_ed
spirted103913073s_pirted
spumed114711543spu__med
spurned10339263spu_rned
spurred103610623spu_rred
spurted103111973spu_rted
squadded2033843squadded
squalled1835943squalled
square154513363squar_e_
squarer163410663squar_er
squares163714463squar_es
squashed21215983squashed
squatted1835343squatted
squawked2543013squawked
squeaked2283903squeaked
squealed1885353squealed
squeezed2743253squeezed
squegged2042893squegged
squid154211903squi___d
squiggled2142453squiggled
squilgee1844623squilgee
squilgeed2042203squilgeed
squinched2443083squinched
squinnied1942673squinnied
squinter1747363squinter
squireens1842733squireens
squiring18177563squiring
squirish2045113squirish
squirmiest2142793squirmiest
squirming2143223squirming
squirreled2051513squirreled
squirrels18333423squirrels
squirrely21283333squirrely
squirt153812933squir__t
squirters1835073squirters
squirts16348013squir_ts
squishes20198393squishes
squushed21193703squushed
stirred8359703s_tirred
stormed1039043s_tormed
stummed12348553stu_mmed
suited74019423s_ui_ted
summed114014043s_u_mmed
surfed103814463s_u_rfed
surged84118883s_u_rged
swarmed1367483s_warmed
swirled11308223s_wirled

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.423422437.4
2DLD Change Limit1461621146.25023385.9
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.71926594.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.