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

196 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
zizzle1324731(None) 
fizzle17369711fizzle
mizzle16279991mizzle
pizzle16279491pizzle
sizzle14309611sizzle
zizzled15315851zizzled
zizzles14307091zizzles
dazzle1536852dazzle
drizzle16285912drizzle
fizzled19357272fizzled
fizzles18339062fizzles
frizzle18367042frizzle
grizzle16306112grizzle
guzzle15297912guzzle
mizzled18327632mizzled
mizzles17329492mizzles
mizzly19256102mizzly
muzzle16319392muzzle
nozzle14236632nozzle
nuzzle14298082nuzzle
pizzles17329272pizzles
puzzle16318602puzzle
sizzled16367882sizzled
sizzler15266862sizzler
sizzles15349632sizzles
swizzle1854102swizzle
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
fickle153912973fickle
fiddle113613383fiddle
file75446643fi__le
fille84327403fi_lle
fimble133611753fimble
finale94116763finale
fipple13329063fipple
fizz157519823fizz__
fizzed18369443fizzed
fizzer17369383fizzer
fizzes174512553fizzes
fizzier18326713fizzier
fizzy199015083fizz_y
foozle18369203foozle
frazzle18305223frazzle
frizzled20325703frizzled
frizzler19345843frizzler
frizzles19297283frizzles
frizzly21455793frizzly
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
tingle74319063tingle
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
zigzag1642963zigzag
zill135727613zi__ll
zills144020783zi_lls
zine137036153zi__ne
zizit13313273zi_zit
zizith1744823zizith
zizzling16233923zizzling
zonule1577483zonule
zzz1017911913z_zz__

Search took 6 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.376475242.0
2DLD Change Limit1127161964.62324381.6
3Display Results1961960.0633111.1
 (SQL Overall)1786911965.06235300.5
 
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.