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

139 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
frizzier1928481(None) 
fizzier18326711f_izzier
frizzer18446891frizz_er
frizzies19315931frizzies
frizzler19345841frizzler
frizzlier20122881frizzlier
dizzier16317542_dizzier
drizzlier18122302drizzlier
fizzer17369382f_izz_er
frillier1136512frillier
fringier1236552fringier
friskier1535192friskier
frizer184011282fri_z_er
frizzed19375972frizz_ed
frizzers19335102frizz_ers
frizzes18338182frizz_es
frizziest20294142frizziest
frizzily2253142frizzily
frizzing2064802frizzing
frizzle18367042frizzle_
frizzled20325702frizzled
frizzlers20293672frizzlers
frizzles19297282frizzles
frouzier2043702frouzier
frowzier2343312frowzier
fuzzier18256522f_uzzier
grizzler17335032grizzler
grizzlier18112452grizzlier
ritzier16297202_ritzier
whizzier2233282whizzier
brazier183911473br_azier
breezier1934533breezier
brickier16307163brickier
brinier93613473bri_nier
bronzier1935633bronzier
crazier183610743cr_azier
crimpier14287323crimpier
crispier12297253crispier
crozier18369933cr_ozier
ditzier17307963_ditzier
dizzied17236133_dizzied
dizzies16279753_dizzies
driftier1275123driftier
drippier1385043drippier
drizzle16285913drizzle_
drizzled18284573drizzled
drizzles17295293drizzles
feistier1136193feistier
fierier103511193f_ierier
filmier1237503f_ilmier
finnier10319953f_innier
firrier103410133f_irrier
fishier13359853f_ishier
fizzed18369443f_izz_ed
fizzers18357003f_izz_ers
fizzes174512553f_izz_es
fizziest19226073f_izziest
fizzing19276403f_izzing
fizzle17369713f_izzle_
fizzled19357273f_izzled
fizzles18339063f_izzles
flimsier1344133flimsier
flintier1136393flintier
flirtier1144893flirtier
fozier183710663f__ozier
frazzle18305223frazzle_
frazzled20303993frazzled
frazzles19284813frazzles
freakier15246483freakier
freezer19348523freez_er
frenzied2144043frenzied
frenzies2037713frenzies
frettier1156593frettier
friaries11310083friaries
fribbler15265953fribbler
frier85225843fr___ier
frieze18378143friez_e_
friezes19418913friez_es
friller104111743fri_ller
frisker14389273fri_sker
fritter103912773fri_tter
fritzes19329453fritz_es
frivoler1443933frivoler
frized193510683fri_z_ed
frizers19329553fri_z_ers
frizes184015463fri_z_es
frizing203310873fri_zing
frizz165512623frizz___
frizziness2142713frizziness
frizzliest21132933frizzliest
frizzling2153113frizzling
frizzly21455793frizz_ly
frizzy20555833frizz__y
froggier1354643froggier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
frowsier1444893frowsier
fruitier1136593fruitier
frumpier1534173frumpier
furzier19318103f_urzier
glitzier1833593glitzier
grazier173611133gr_azier
grimier103210433gri_mier
gripier103210323gri_pier
grippier1355203grippier
grislier935793grislier
grittier9316263grittier
grizzle16306113grizzle_
grizzled18334893grizzled
grizzlers18253233grizzlers
grizzles17286193grizzles
grizzlies18123193grizzlies
jazzier2233883_jazzier
muzzier17326553_muzzier
pricier113313113pri_cier
prickier16368143prickier
prissier10157873prissier
privier122910453pri_vier
prizer174714883pri_z_er
quizzer2434393quizz_er
ribbier1137593_ribbier
ribier84414233_ri_bier
ridgier937883_ridgier
rimier83916273_ri_mier
riskier1138423_riskier
rozzer1437353_rozz_er
schizzier2242253schizzier
scuzzier1842713scuzzier
sizier1514813393_si_zier
sizzler15266863_sizzler
snazzier1642483snazzier
swizzler1963223swizzler
tizzies15287893_tizzies
trickier143010233trickier
trippier1246623trippier
vizier184311023_vi_zier
whizzer2134583whizz_er
wristier1136863wristier

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.406440125.6
2DLD Change Limit1461621396.58022213.1
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.03225411.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.