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

126 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
frazzle1830522(None) 
frazzled20303991frazzled
frazzles19284811frazzles
frizzle18367041frizzle
dazzle1536852_dazzle
drizzle16285912drizzle
fizzle17369712f_izzle
fragile1147842fragile
frazil1847222frazil_
frazils1956122frazils
frizzled20325702frizzled
frizzler19345842frizzler
frizzles19297282frizzles
frizzly21455792frizzly
grizzle16306112grizzle
arable81821003ara_ble
azole145118033__azole
bedazzle1942143bedazzle
brabble10349973brabble
braille939713braille
braize174113113braiz_e
bramble133710033bramble
brattle9249253brattle
braze165423453bra_z_e
brazil1779623brazil_
brazils1867753brazils
crackle153611253crackle
cradle93313163cra_dle
crankle133610063crankle
craze165221463cra_z_e
crazily2136923crazily
dazzled1735033_dazzled
dazzler1634713_dazzler
dazzles1636413_dazzles
diazole1736793diazole
drabble12238883drabble
draggle1056103draggle
drizzled18284573drizzled
drizzles17295293drizzles
drizzly19364553drizzly
fable105824753f_a_ble
facile112514883f_acile
faille93414743f_aille
farle86929243f_a_rle
faze165630043f_a_z_e
feaze175216313fea_z_e
fizzled19357273f_izzled
fizzles18339063f_izzles
foozle18369203f_oozle
frae75330473fra___e
frail85220213fra_il_
frailer10319943fra_iler
frailly1337313frailly
frails93716473fra_ils
fraise94214913fra_ise
framable1537573framable
frame105821803fra__me
frankly17315633frankly
frappe13286953fra_ppe
frazzling2143153frazzling
freckle16106643freckle
freeze18349513freez_e
friable122612563friable
fribble14287783fribble
frieze18378143friez_e
frijole1734583frijole
frizz165512623frizz__
frizzed19375973frizzed
frizzer18446893frizzer
frizzes18338183frizzes
frizzier19284813frizzier
frizzies19315933frizzies
frizzily2253143frizzily
frizzlers20293673frizzlers
frizzlier20122883frizzlier
frizzy20555833frizz_y
froze174515653fr_oz_e
fryable15277463fryable
grabble12339643grabble
gracile102512603gracile
grackle14338893grackle
granule839473granule
grapple12378003grapple
grazable2036223grazable
graze155820053gra_z_e
grizzled18334893grizzled
grizzler17335033grizzler
grizzles17286193grizzles
grizzly19354473grizzly
guzzle15297913_guzzle
mizzle16279993_mizzle
muzzle16319393_muzzle
nozzle14236633_nozzle
nuzzle14298083_nuzzle
oracle84313293ora_cle
piazze1634683piazz_e
pizzle16279493_pizzle
prattle9208833prattle
puzzle16318603_puzzle
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
ramble104519973_ramble
rankle103414883_rankle
rassle63813203_rassle
rattle64717613_rattle
raze135235433_ra_z_e
razee145827803_ra_zee
razz125219423_razz__
razzed15478283_razzed
razzes144910063_razzes
sizzle14309613_sizzle
spatzle1834573spatzle
swizzle1854103swizzle
tazze1339573_tazz_e
teazle15329553tea_zle
trachle12311853trachle
trample11299703trample
triazole1744153triazole
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle
zizzle13247313_zizzle

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271266.70319995.1
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.90525878.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.