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

124 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
frazzles1928481(None) 
frazzle18305221frazzle_
frazzled20303991frazzled
frizzles19297281frizzles
dazzles1636412_dazzles
drizzles17295292drizzles
fizzles18339062f_izzles
frazils1956122frazil_s
frizzes18338182frizz_es
frizzies19315932frizzies
frizzle18367042frizzle_
frizzled20325702frizzled
frizzler19345842frizzler
frizzlers20293672frizzlers
grizzles17286192grizzles
razzes144910072_razz_es
arables91814973ara_bles
azoles154614613__azoles
bedazzles2042063bedazzles
brabbles11349753brabbles
brailles1039493brailles
braizes183112453braiz_es
brambles14308973brambles
brattles10199333brattles
brazes175522193bra_z_es
brazils1867753brazil_s
crackles164111273crackles
cradles103114133cra_dles
crankles143510153crankles
crazes174720133cra_z_es
crazies183413853cra_zies
dazzle1536853_dazzle_
dazzled1735033_dazzled
dazzler1634713_dazzler
dazzlers1733233_dazzlers
diazoles1836323diazoles
drabbles13308523drabbles
draggles1145963draggles
drizzle16285913drizzle_
drizzled18284573drizzled
fables114921673f_a_bles
failles102914133f_ailles
farles96025783f_a_rles
fazes175527213f_a_z_es
feazes184514173fea_z_es
fezzes174910403f_ezz_es
fizzes174512553f_izz_es
fizzle17369713f_izzle_
fizzled19357273f_izzled
foozles19329543f_oozles
fracases1336993fracases
fragile1147843fragile_
frailer10319943fra_iler
frailest1139493fra_ilest
frails93716473fra_il_s
fraises104215693fra_ises
frameless1435533frameless
frames115119863fra__mes
frappes14328383fra_ppes
frasses104314513fra_sses
frazil1847223frazil__
frazzling2143153frazzling
freckles17126383freckles
freezes193310353freez_es
frenzies2037713frenzies
fribbles15287713fribbles
friezes19418913friez_es
frijoles1834373frijoles
fritzes19329453fritz_es
frizes184015463fr_iz_es
frizzed19375973frizz_ed
frizzer18446893frizz_er
frizzers19335103frizzers
frizzier19284813frizzier
frizziest20294143frizziest
frizzlier20122883frizzlier
frizzliest21132933frizzliest
frizzly21455793frizzl_y
fuzzes175412253f_uzz_es
grabbles13339893grabbles
graciles112511613graciles
grackles15309183grackles
granules939933granules
grapples13348123grapples
grazes164519643gra_z_es
grizzle16306113grizzle_
grizzled18334893grizzled
grizzler17335033grizzler
grizzlers18253233grizzlers
grizzlies18123193grizzlies
guzzles16328043_guzzles
jazzes21347883_jazz_es
mizzles17329493_mizzles
muzzles17299683_muzzles
nozzles15276303_nozzles
nuzzles15298123_nuzzles
oracles93212423ora_cles
pizzles17329273_pizzles
prattles10189403prattles
puzzles17318973_puzzles
rabbles113517973_rabbles
raddles93615703_raddles
raffles133611843_raffles
raggles93813283_raggles
rales54947493_ra__les
rambles113118313_rambles
rankles113114543_rankles
rassles73513923_rassles
rattles73217303_rattles
razees154314763_ra_zees
razes145032703_ra_z_es
razzed15478283_razz_ed
sizzles15349633_sizzles
spatzles1935303spatzles
spazzes1735263spazz_es
swizzles1953783swizzles
teazles16308923tea_zles
trachles13311753trachles
tramples122610203tramples
triazoles1844393triazoles
wrangles1237463wrangles
wrassles11376713wrassles
wrastles11328933wrastles
zizzles14307093_zizzles

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621247.64319123.6
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.14221946.8
 
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.