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

227 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
nozzle1423663(None) 
nozzles15276301nozzles
nuzzle14298081nuzzle
dazzle1536852dazzle
fizzle17369712fizzle
foozle18369202foozle
guzzle15297912guzzle
mizzle16279992mizzle
muzzle16319392muzzle
nobble103814312nobble
noble74420992no_ble
noddle83211362noddle
nodule7309802nodule
noodle73212542noodle
nuzzled16276392nuzzled
nuzzler15296492nuzzler
nuzzles15298122nuzzles
pizzle16279492pizzle
pozole1758912pozole
puzzle16318602puzzle
sizzle14309612sizzle
snoozle16305912snoozle
sozzled16265182sozzled
touzle15429002touzle
zizzle13247312zizzle
anole55330373ano__le
azole145118033_azole
bobble94115143bobble
boggle104511943boggle
bogle85821683bo_gle
bole66448693bo__le
bonze165119353bonz_e
boodle93215033boodle
booze164718913booz_e
bottle84916073bottle
boucle103712783boucle
boule74828043bo_ule
boulle84614613boulle
cobble123615263cobble
coble94823173co_ble
cockle143913573cockle
coddle104713853coddle
coffle14359043coffle
cole66956113co__le
couple104415963couple
cozie163519133co_zie
cozily20349703cozily
cozzes164510893cozzes
dazzled1735033dazzled
dazzler1634713dazzler
dazzles1636413dazzles
doable93115243doable
docile94213123docile
dole56550003do__le
dongle83612493dongle
donzel1636313donzel
doodle83212853doodle
doozie163910653doozie
dottle74212503dottle
double94013993double
doze145829083do_z_e
dozily19329103dozily
drizzle16285913drizzle
fizzled19357273fizzled
fizzles18339063fizzles
foible11410383foible
fondle104412943fondle
footle93914383footle
foozled20346893foozled
foozler19397593foozler
foozles19329543foozles
frazzle18305223frazzle
frizzle18367043frizzle
gobble113512983gobble
goggle94511573goggle
grizzle16306113grizzle
guzzled17326263guzzled
guzzler16286563guzzler
guzzles16328043guzzles
hobble133913433hobble
hole77553393ho__le
hondle103914523hondle
hopple132910483hopple
hoyle11314413ho_yle
joggle154010353joggle
jole117233823jo__le
jostle13319863jostle
joule124918203jo_ule
lezzie1435333lezzie
lobule82910063lobule
locale83915653locale
locule83412033locule
mizzled18327633mizzled
mizzles17329493mizzles
mizzly19256103mizzly
mobile103613543mobile
module93011033module
mole66251833mo__le
morale85220553morale
motile83818343motile
mottle84116053mottle
muzzled18267753muzzled
muzzler17257943muzzler
muzzles17299683muzzles
nebule848753nebule
needle73310613needle
nestle63013953nestle
nettle64514583nettle
nibble103713283nibble
nickle123814483nickle
niggle83612823niggle
nimble103412943nimble
nipple103410373nipple
nobbled123511283nobbled
nobbler113211183nobbler
nobbles114014523nobbles
nobler83713453no_bler
nobles83319723no_bles
nobly105314403no_bly
noctule936083noctule
nodal64717793nodal_
noddled10358563noddled
noddles92911293noddles
node513036883no__de
nodose738883nodose
nodules8269703nodules
noel45226553no_el_
noels56418703no_els
noil46133243no_il_
noils55024333no_ils
noily86120993no_ily
noise55723733no_ise
nolo46229313no__lo
nombles113212343nombles
nome66038423no__me
nonage7313683nonage
nonce75719823no_nce
none45743173no__ne
nonuple946153nonuple
nonuse63212253nonuse
nonyl849773nonyl_
nonyls957853nonyls
noodge8337573noodge
noodled9339923noodled
noodles83513193noodles
noogie73612313noogie
nookie103712433nookie
noose55624063no_ose
nopal75517103nopal_
nopales93812523nopales
nopals84914023nopals
nope65934193no__pe
norite63221133norite
nose46739363no__se
nosily93712683nosily
notable92114903notable
notal55221353notal_
notate63217863notate
note46239963no__te
notice8313443notice
novae85913123no_vae
novel85615993novel_
novelle1058233novelle
novels95512503novels
novice1138433novice
nowise9511073nowise
noyade1036423noyade
nubble103813713nubble
nubile83212713nubile
nuncle839363nuncle
nuzzlers16244753nuzzlers
obole75917143_obole
odyle9349593_odyle
ogle56325053_o_gle
ole37155213_o__le
ooze136420603_ooz_e
oozily18328073oozily
orle45630463_o_rle
ouzel144612323_ouzel
ovule839493_ovule
ozone14310613_ozone
pizzles17329273pizzles
pole65951303po__le
poodle93112043poodle
popple92710983popple
posole8314223posole
pottle84416103pottle
pozoles1839063pozoles
puzzled18286653puzzled
puzzler17276963puzzler
puzzles17318973puzzles
roble75223023ro_ble
role45851823ro__le
rootle63214453rootle
rouble83913313rouble
rozzer1437353rozzer
schnozzle2251453schnozzle
sizzled16367883sizzled
sizzler15266863sizzler
sizzles15349633sizzles
snooze15439993snooz_e
snoozled18344493snoozled
snoozles17335563snoozles
socle7419573so_cle
sole46053673so__le
sozine15712353sozine
swizzle1854103swizzle
tazze1339573tazz_e
teazle15329553teazle
toddle85811033toddle
toggle83810873toggle
toile54626493to_ile
tole46052903to__le
tootle62613813tootle
topple104411323topple
tousle64514653tousle
touzled17367153touzled
touzles16359223touzles
unmuzzle1842303unmuzzle
unpuzzle1842303unpuzzle
voile84719723vo_ile
vole75236983vo__le
wobble133212313wobble
yodle94515043yo_dle
zizzled15315853zizzled
zizzles14307093zizzles
zonule1577483zonule

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.266671770.7
2DLD Change Limit1127162275.59320153.0
3Display Results2272270.0762986.8
 (SQL Overall)1786912275.93530108.0
 
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.