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

303 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
fizzle1736971(None) 
fizzled19357271fizzled
fizzles18339061fizzles
frizzle18367041frizzle
mizzle16279991mizzle
pizzle16279491pizzle
sizzle14309611sizzle
zizzle13247311zizzle
dazzle1536852dazzle
drizzle16285912drizzle
fickle153912972fickle
fiddle113613382fiddle
file75446642fi__le
fille84327402fi_lle
fimble133611752fimble
finale94116762finale
fipple13329062fipple
fizz157519822fizz__
fizzed18369442fizzed
fizzer17369382fizzer
fizzes174512552fizzes
fizzier18326712fizzier
fizzy199015082fizz_y
foozle18369202foozle
frazzle18305222frazzle
frizzled20325702frizzled
frizzler19345842frizzler
frizzles19297282frizzles
frizzly21455792frizzly
grizzle16306112grizzle
guzzle15297912guzzle
mizzled18327632mizzled
mizzles17329492mizzles
mizzly19256102mizzly
muzzle16319392muzzle
nozzle14236632nozzle
nuzzle14298082nuzzle
pizzles17329272pizzles
puzzle16318602puzzle
sizzled16367882sizzled
sizzler15266862sizzler
sizzles15349632sizzles
swizzle1854102swizzle
zizzled15315852zizzled
zizzles14307092zizzles
aisle55223193ai_sle
azole145118033_azole
bible95119423bi_ble
bile66147183bi__le
bindle94516263bindle
birle75023633bi_rle
bize155926293bi_z_e
bizone1738603bizone
bizzes163910843bizzes
cicale10314503cicale
circle1039703circle
citole8311503citole
dazzled1735033dazzled
dazzler1634713dazzler
dazzles1636413dazzles
diazole1736793diazole
dibble114013843dibble
diddle94915213diddle
dimple113512793dimple
dindle84417223dindle
dingle84317073dingle
dipole91112853dipole
dizzied17236133dizzied
dizzier16317543dizzier
dizzies16279753dizzies
dizzily1934843dizzily
dizzy177410853dizz_y
drizzled18284573drizzled
drizzles17295293drizzles
drizzly19364553drizzly
fable105824753f_able
facile112514883facile
faille93414743faille
farle86929243f_arle
faze165630043f_az_e
feaze175216313feaz_e
feeble1138253feeble
feeze174913823feez_e
female11310553female
ferule93413203ferule
fettle93713123fettle
fezzed18398243fezzed
fezzes174910403fezzes
fezzy199811453fezz_y
fiacre1137623fiacre
fiance11310743fiance
fibre104812843fi_bre
fibula11258053fibula
fibulae12237013fibulae
fice95737113fi__ce
fiche134616743fi_che
fickler16348423fickler
fickly18318533fickly
fictile1238023fictile
fiddled13329633fiddled
fiddler12309953fiddler
fiddles123212603fiddles
fiddly14328483fiddly
fidge104516063fi_dge
fie67152443fi___e
field95015323fi_eld
fierce11348913fierce
fife106027703fi__fe
figure10258833figure
fil65447143fi__l_
fila74729133fi__la
filed95331903fi__led
filer85433003fi__ler
files85441273fi__les
filet85540163fi__let
fill75540193fi__ll
filled104922263fi_lled
filler94623623fi_ller
filles94224523fi_lles
fillet95027083fi_llet
fillo84319783fi_llo
fills84632373fi_lls
filly114424903fi_lly
film94828173fi__lm
filo76034283fi__lo
filose96112503filose
fils75838693fi__ls
fimbles143510663fimbles
finable122213623finable
finagle11238313finagle
final83922033final_
finales104016013finales
finals94316163finals
fine75147953fi__ne
finely123011563finely
finite9316823finite
fipples14298653fipples
fique1739143fi_que
fire76245593fi__re
firmly1436663firmly
fissile10269653fissile
fitly115114973fi_tly
five107629743fi__ve
fixable19218193fixable
fixate1638733fixate
fixure16256543fixure
fiz156238763fi_z__
fizgig2032973fizgig
fizzers18357003fizzers
fizziest19226073fizziest
fizzing19276403fizzing
fizzling20264993fizzling
foible11410383foible
fondle104412943fondle
footle93914383footle
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
frazzled20303993frazzled
frazzles19284813frazzles
friable122612563friable
fribble14287783fribble
frieze18378143friez_e
frijole1734583frijole
frizz165512623frizz__
frizzed19375973frizzed
frizzer18446893frizzer
frizzes18338183frizzes
frizzier19284813frizzier
frizzies19315933frizzies
frizzily2253143frizzily
frizzlers20293673frizzlers
frizzlier20122883frizzlier
frizzy20555833frizz_y
froze174515653froz_e
fuddle113312103fuddle
fugle94915543f_ugle
fumble133214263fumble
furze176815813furz_e
fusile94313493fusile
futile93914953futile
fuze166422373f_uz_e
fuzee175718883f_uzee
fuzil173810703fuzil_
fuzils18407963fuzils
fuzz158420573fuzz__
fuzzed18479253fuzzed
fuzzes175412253fuzzes
fuzzier18256523fuzzier
fuzzily2145073fuzzily
fuzzy1929814513fuzz_y
giggle94313513giggle
girdle82110463girdle
grizzled18334893grizzled
grizzler17335033grizzler
grizzles17286193grizzles
grizzly19354473grizzly
guzzled17326263guzzled
guzzler16286563guzzler
guzzles16328043guzzles
higgle113811743higgle
hirple11158973hirple
hirsle9159573hirsle
idle55423763_i_dle
ingle64120433_ingle
inkle94515833_inkle
isle45121703_i_sle
istle52214713_istle
ixtle12168013_ixtle
jiggle153811993jiggle
jingle143815223jingle
kibble143910953kibble
kindle114414233kindle
kirtle10309473kirtle
kittle104012173kittle
lezzie1435333lezzie
liable81415813liable
ligule74010833ligule
lisle53916723li_sle
little63312163little
mickle143715133mickle
middle103414983middle
miggle104012113miggle
mile66352573mi__le
mille75029133mi_lle
mingle93518783mingle
mizzen16447953mizzen
muzzled18267753muzzled
muzzler17257943muzzler
muzzles17299683muzzles
nibble103713283nibble
nickle123814483nickle
niggle83612823niggle
nimble103412943nimble
nipple103410373nipple
nozzles15276303nozzles
nuzzled16276393nuzzled
nuzzler15296493nuzzler
nuzzles15298123nuzzles
piazze1634683piazze
pickle144215653pickle
piddle103514913piddle
piffle14418233piffle
pile65649693pi__le
pilule8411123pilule
pimple123512963pimple
pinole83218783pinole
pintle83818263pintle
pizza1538183pizz_a
pizzas1646983pizzas
pizzaz1565443pizzaz
pizzelle1842913pizzelle
pozole1758913pozole
puzzled18286653puzzled
puzzler17276963puzzler
puzzles17318973puzzles
riddle83915713riddle
riffle124210233riffle
rifle85518333ri_fle
rile45650533ri__le
rille55728733ri_lle
rimple103814583rimple
ripple103413913ripple
sickle124418323sickle
sidle65124033si_dle
simile83115633simile
simple104315173simple
single74520603single
sizable1839893sizable
size135630963si_z_e
sizzlers16274753sizzlers
sozzled16265183sozzled
swizzled2053013swizzled
swizzler1963223swizzler
swizzles1953783swizzles
tazze1339573tazz_e
teazle15329553teazle
tickle124616743tickle
tile45451443ti__le
tingle74319073tingle
tinkle103714453tinkle
tipple103411913tipple
title54721073ti_tle
tittle63613323tittle
tizzies15287893tizzies
tizzy16548893tizz_y
touzle15429003touzle
viable111613773viable
vile76139803vi__le
virile9313433virile
vittle94711753vittle
vizsla1833703vizsla
widdle113814843widdle
wiggle113713013wiggle
wile75944373wi__le
wimble133211923wimble
wimple133611363wimple
windle104617953windle
winkle133812833winkle
wintle94014603wintle
winze175014853winz_e
wizzen17387203wizzen
wizzes175110773wizzes

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 Filter1786911127160.390458182.1
2DLD Change Limit1127163035.61020092.0
3Display Results3033030.0963156.3
 (SQL Overall)1786913036.09629312.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.