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 “towie” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
towie8582187(None) 
dowie94721141dowie
tawie84819811tawie
towies93521191towies
townie93312301townie
yowie114616451yowie
zowie174313841zowie
bogie89524102bogie
bowse105420632bowse
cosie74728262cosie
cowier113616162cowier
cowpie133511512cowpie
cowrie113814282cowrie
cozie163519132cozie
dobie84920332dobie
dogie75222792dogie
dowse96020812dowse
doxie136017152doxie
fogie96719002fogie
homie104622532homie
howdie13349732howdie
howe106734102how_e
looie55624242looie
louie55023512louie
lowe75435312low_e
lowse87219902lowse
monie75631652monie
movie105319132movie
moxie144018122moxie
newie81813482newie
nowise9511072nowise
oorie53026362oorie
owe67041032_ow_e
owse76321622_owse
stogie7311322stogie
tawpie11339142tawpie
tawse85616502tawse
tie36557532t__ie
tobies84521022tobies
todies74223552todies
toe310166852to__e
togae67020112togae
togue64816302togue
toil46536282to_il
toile54626492toile
toit46353062to_it
toke86738492to_ke
tole46052902to_le
tome67543192to_me
tone46953742to_ne
tonic74727652tonic
tonier65520712tonier
tonne54921432tonne
toonie63617992toonie
tope65946382to_pe
topee76029952topee
tophe106718972tophe
topi67830392topi_
topic95721502topic
topis76025832topis
toque145113092toque
tore47359322to_re
tori47542152tori_
toric76529312toric
tories65435882tories
torii55521592torii
torse55833332torse
torte55431702torte
tote46643672to_te
touse55430672touse
tow610557362tow__
towage1039832towage
towed95134582towed
towel84920522towel
tower85729202tower
towhee122613882towhee
towing103823192towing
towline102911542towline
town76928702tow_n
townee92815212townee
townies103113622townies
towns86018882towns
towny116114492towny
tows78545552tow_s
towy105325472tow_y
toxic145315622toxic
toxin124716712toxin
toxine133114122toxine
twae74719572t_wae
twee76827082t_wee
twice104711122t_wice
twier84713292t_wier
twig87615772t_wig
twin76023082t_win
twine85822362t_wine
twit76329062t_wit
vogie95116662vogie
yowe106728742yow_e
yowies123913732yowies

Search took 2 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 Filter178691538000.343520965.0
2DLD Change Limit53800991.47036598.6
3Display Results99990.0137615.4
 (SQL Overall)178691991.82697859.3
 
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.