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

102 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
squeaking233421(None) 
squealing1935151squealing
quaking2139312_qu_aking
screaking16228242screaking
sneaking133211092s_neaking
speaking153212492s_peaking
squaring18158632squ_aring
squawking2642432squawking
squeakier2242902squeakier
squeakily2542002squeakily
squeezing2843082squeezing
squegging2162502squegging
streaking142010322streaking
breaking153914253_breaking
creaking153414123_creaking
debeaking1735923debeaking
equaling1837793equ_aling
equating18310113equ_ating
freaking163611453_freaking
leaking123616973__leaking
peaking144317693__peaking
phreaking1936473phreaking
quacking2436743_quacking
queening1846113_queening
queering1838203_queering
quelling18259793_quelling
querying2135243_querying
questing1838273_questing
queueing1842873_queueing
queuing1736233_que_uing
quirking22215123_quirking
saunaing937013sauna_ing
screaming14217833screaming
scubaing1335733scuba_ing
sculking15307913scu_lking
sealing83528563s__ealing
seaming103222113s__eaming
searing83330923s__earing
seating84130683s__eating
seeking124016063s__eeking
sequencing2243053sequencing
shaking153317253s__haking
sheafing15329483s_heafing
shealing123415463s_healing
shearing123915903s_hearing
sheaving154110253s_heaving
shucking18339433shu_cking
skulking12245903sku_lking
skunking12256653sku_nking
slaking123717473s__laking
sleaving123310983s_leaving
sleeking133410963s_leeking
smearing113511753s_mearing
smeeking15317833s_meeking
smerking15258473s_merking
snaking123915303s__naking
sneaping11349493s_neaping
soaking123116613s__oaking
speakings16345933s_peakings
speaning113512243s_peaning
spearing113216103s_pearing
specking17359733s_pecking
spreading1339653spreading
spunking15258063spu_nking
squadding2143233squadding
squalling1935173squalling
squashing2234703squashing
squatting1934513squatting
squeak1935253squeak___
squeaked2283903squeak_ed
squeaker2184883squeak_er
squeakers2284113squeakers
squeakiest2342793squeakiest
squeaks2034523squeak__s
squeaky2343083squeak__y
squeamish2342653squeamish
squelching2542233squelching
squibbing2342753squibbing
squidding2143153squidding
squinting1936223squinting
squiring18177563squ_iring
squirming2143223squirming
squirting1934793squirting
squishing2234953squishing
squushing2242943squushing
staking123919803s__taking
steading103613593s_teading
stealing93416603s_tealing
steaming114013213s_teaming
steeking133411353s_teeking
streakings15235303streakings
streaming12239653streaming
streeking14217453streeking
sucking143217413s_u_cking
sueding92613753s_ue_ding
sugaring1039053s_ugaring
sulking124514313s_u_lking
swearing123711443s_wearing
sweating123213023s_weating
tweaking1635883_tweaking
unquaking2354593unqu_aking
wreaking163010213_wreaking

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 Filter1786911486410.466383457.1
2DLD Change Limit1486411026.86021667.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.37224239.1
 
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.