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 “frizzler” 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
frizzler1934584(None) 
frizzer18446891frizz_er
frizzier19284811frizzier
frizzle18367041frizzle_
frizzled20325701frizzled
frizzlers20293671frizzlers
frizzles19297281frizzles
frizzlier20122881frizzlier
grizzler17335031grizzler
drizzle16285912drizzle_
drizzled18284572drizzled
drizzles17295292drizzles
drizzlier18122302drizzlier
fizzer17369382f_izz_er
fizzier18326712f_izzier
fizzle17369712f_izzle_
fizzled19357272f_izzled
fizzles18339062f_izzles
frazzle18305222frazzle_
frazzled20303992frazzled
frazzles19284812frazzles
fribbler15265952fribbler
friller104111742fri_ller
frivoler1443932frivoler
frizer184011282fri_z_er
frizzed19375972frizz_ed
frizzers19335102frizz_ers
frizzes18338182frizz_es
frizzies19315932frizzies
frizzly21455792frizzl_y
grizzle16306112grizzle_
grizzled18334892grizzled
grizzlers18253232grizzlers
grizzles17286192grizzles
grizzlier18112452grizzlier
sizzler15266862_sizzler
swizzler1963222swizzler
bridler103811073bri_dler
brittler10165983brittler
crippler14826713crippler
dazzler1634713_dazzler
dizzier16317543_dizzier
dribbler13316313dribbler
driller84311883dri_ller
driveler1284693driveler
drizzly19364553drizzl_y
fickler16348423f_ickler
fiddler12309953f_iddler
filer85433003f_i__ler
filler94623623f_i_ller
fizzed18369443f_izz_ed
fizzers18357003f_izz_ers
fizzes174512553f_izz_es
foozler19397593f_oozler
frailer10319943fr_ailer
freezer19348523freez_er
friable122612563friable_
fribble14287783fribble_
fribbled16305743fribbled
fribblers16314193fribblers
fribbles15287713fribbles
frier85225843fri___er
frieze18378143friez_e_
friezes19418913friez_es
frijole1734583frijole_
frijoles1834373frijoles
frilled113911603fri_lled
frillers11349863fri_llers
frillier1136513frillier
fringier1236543fringier
frisker14389273fri_sker
friskier1535193friskier
fritter103912773fri_tter
fritzes19329453fritz_es
frivoled1534043frivoled
frivolers1543473frivolers
frivoller1542433frivoller
frized193510683fri_z_ed
frizers19329553fri_z_ers
frizes184015463fri_z_es
frizz165512623frizz___
frizziest20294143frizziest
frizzily2253143frizzily
frizzing2064803frizzing
frizzliest21132933frizzliest
frizzling2153113frizzling
frizzy20555833frizz__y
frouzier2043703frouzier
frowzier2343313frowzier
fuzzier18256523f_uzzier
griller84513353gri_ller
grizzlies18123193grizzlies
grizzly19354473grizzl_y
guzzler16286563_guzzler
mizzle16279993_mizzle_
mizzled18327633_mizzled
mizzles17329493_mizzles
muzzler17257943_muzzler
nuzzler15296493_nuzzler
pizzle16279493_pizzle_
pizzles17329273_pizzles
prizer174714883pri_z_er
puzzler17276963_puzzler
quizzer2434393quizz_er
riddler93411263_riddler
riffler13328353_riffler
rifler94014263_ri_fler
rippler113210103_rippler
ritzier16297203_ritzier
rozzer1437353_rozz_er
sizzle14309613_sizzle_
sizzled16367883_sizzled
sizzlers16274753_sizzlers
sizzles15349633_sizzles
swizzle1854103swizzle_
swizzled2053013swizzled
swizzlers2052193swizzlers
swizzles1953783swizzles
trifler103912153tri_fler
triller74215893tri_ller
whizzer2134583whizz_er
whizzier2233283whizzier
wriggler13295263wriggler
zizzle13247313_zizzle_
zizzled15315853_zizzled
zizzles14307093_zizzles

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621267.07620656.0
3Display Results1261260.0502520.0
 (SQL Overall)1786911267.29924481.6
 
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.