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

121 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
squawks2329488(None) 
squarks20417181squarks
squawk22385371squawk_
squaws18438781squaw_s
quacks214710102_quacks
quarks193810912_quarks
squabs17429322squa_bs
squads164410292squa_ds
squalls1647312squalls
squares163714462squares
squark19438112squark_
squats153712962squa_ts
squaw17368982squaw__
squawked2543012squawked
squawker2443092squawker
squawkers2542482squawkers
squeaks2034522squeaks
aquas142412613aqua__s
dawks135213493__dawks
equals1538703equa_ls
equates162012323equates
gawks136811633__gawks
hawks155415703__hawks
mohawks1942123mohawks
quack203812503_quack_
quacky24376963_quacky
quads154515843_qua_ds
quaffs21125693_quaffs
quags154613253_qua_gs
quails153412643_quails
quais144618393_qua_is
quake184114643_qua_ke
quakes194013343_quakes
quaky214310743_qua_ky
qualms17317243_qualms
quants153614143_quants
quark184614123_quark_
quarts154715933_quarts
quass144413763_qua_ss
quays174612043_qua_ys
quicks21389303_quicks
quirks19419113_quirks
sacks114228873s__acks
sarks96632463s__arks
saws75839483s__aw_s
scrawls12177283scrawls
sculks123610263scu_lks
shacks154817563s_hacks
shanks135315583s_hanks
sharks135019723s_harks
shawls125411973s_hawls
shawms14579563s_hawms
shaws116226263s_haw_s
shucks154010413shu_cks
skanks94710833s_kanks
skuas95611733skua__s
skulks9427243sku_lks
skunks9468163sku_nks
slacks124416533s_lacks
slaws85222713s_law_s
smacks144112323s_macks
snacks124514553s_nacks
snarks104815733s_narks
snaws86116363s_naw_s
sneaks104312493snea_ks
soaks95220293s_oa_ks
souaris7312333souaris
souks94820523sou__ks
spanks124514123s_panks
sparks124616363s_parks
spawns11577923s_pawns
speaks125114583spea_ks
sprawls12176373sprawls
spunks12349333spu_nks
squab163810733squa__b
squabby2343283squabby
squad155110793squa__d
squalid1737053squalid
squall1538003squa_ll
squally1937673squally
squalor1644423squalor
squalors1744583squalors
squama1736533squa_ma
squamae1845723squamae
squamose1944273squamose
squamous1944673squamous
square154513363squa_re
squared173610563squared
squarer163410663squarer
squarers17338023squarers
squarest17338223squarest
squarish2047323squarish
squash1846833squa_sh
squashes20207803squashes
squashy2233843squashy
squat143720143squa__t
squatly1946433squatly
squatty1964823squatty
squawbush2651313squawbush
squawfish2742263squawfish
squawking2642433squawking
squeak1935253squeak_
squeaky2343083squeaky
squeals1636513squeals
squegs1675643squ_egs
squibs17317453squ_ibs
squids16409803squ_ids
squills1666313squills
squints16339033squints
squires163812843squires
squirms18376343squirms
squirts16348013squirts
stacks124317263s_tacks
stalks104614553s_talks
stanks104917703s_tanks
steaks104415853stea_ks
straws98718673straw_s
sucks114523073s_u_cks
suks85927123s_u__ks
sulks94818463s_u_lks
swanks134811563s_wanks

Search took 9 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.406440125.6
2DLD Change Limit1340271217.64017542.8
3Display Results1211210.0333666.7
 (SQL Overall)1786911218.07922118.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.