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

296 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
pizzle1627949(None) 
fizzle17369711fizzle
mizzle16279991mizzle
pizzles17329271pizzles
puzzle16318601puzzle
sizzle14309611sizzle
zizzle13247311zizzle
dazzle1536852dazzle
drizzle16285912drizzle
fizzled19357272fizzled
fizzles18339062fizzles
frizzle18367042frizzle
grizzle16306112grizzle
guzzle15297912guzzle
mizzled18327632mizzled
mizzles17329492mizzles
mizzly19256102mizzly
muzzle16319392muzzle
nozzle14236632nozzle
nuzzle14298082nuzzle
piazze1634682piazze
pickle144215652pickle
piddle103514912piddle
piffle14418232piffle
pile65649692pi__le
pilule8411122pilule
pimple123512962pimple
pinole83218782pinole
pintle83818262pintle
pizza1538182pizz_a
pizzas1646982pizzas
pizzaz1565442pizzaz
pizzelle1842912pizzelle
pozole1758912pozole
puzzled18286652puzzled
puzzler17276962puzzler
puzzles17318972puzzles
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
epistle957893epistle
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
paddle104615143paddle
padle84522343p_adle
pale66055013p__ale
papule102212133papule
parle75836163p_arle
parole84425253parole
pebble1238003pebble
peddle103512823peddle
pele65539553p__ele
penile82219603penile
people10310183people
pestle83215843pestle
pettle84116053pettle
phyle134111153p_hyle
piaffe1494913piaffe
pial65636703pi_al_
piazza1643823piazza
piazzas1743643piazzas
pibal95217323pibal_
pibals103813083pibals
pical95524373pical_
pice84641093pi__ce
pickled164011883pickled
pickles153215443pickles
picul95015363picul_
piculs103511753piculs
piddled123311253piddled
piddler112911523piddler
piddles114314273piddles
piddly13319143piddly
pie55457403pi___e
piece96717993pi_ece
piehole12188553piehole
pierce104010393pierce
piffled16366403piffled
piffles15368763piffles
piggie103210773piggie
piglet93420923pi_glet
pikake11115803pikake
pike106335213pi__ke
pilea75123953pi__lea
piled85232993pi__led
pilei74021783pi__lei
piles74742613pi__les
pili66130353pi__li
pill65339463pi__ll
pilled94222753pi_lled
pills74130973pi_lls
pilose84514233pilose
pilules9510623pilules
pily96132733pi__ly
pimpled14289183pimpled
pimples133012423pimples
pimply15329213pimply
pine67755713pi__ne
pinene82915643pinene
pinhole122010433pinhole
pinite8321243pinite
pinkie124414273pinkie
pinkly155012243pinkly
pinnae84414643pinnae
pinnule936003pinnule
pinocle1138143pinocle
pinoles93418703pinoles
pintles94118723pintles
pinwale1257843pinwale
piolet83225643pi_olet
pipage1199143pipage
pipal95118353pipal_
pipals104213643pipals
pipe86434433pi__pe
pique16410173pi_que
pirate82322883pirate
piste75824603pi_ste
pistole92414313pistole
pixel143911903pixel_
pixels15478533pixels
pixie145415523pi_xie
pizazz1554223pizazz
pizazzes1742373pizazzes
pizazzy1952243pizazzy
pizzalike2341803pizzalike
pizzazes1752513pizzazes
pizzazz0243023pizzazz
pizzelles1942943pizzelles
pliable111610323pliable
pole65951303p__ole
poodle93112043poodle
popple92710983popple
posole8314223posole
pottle84416103pottle
pozoles1839063pozoles
prickle153611013prickle
prize164718943priz_e
prole74527793p_role
puddle103914153puddle
pule65040953p__ule
pungle94413573pungle
purfle112511183purfle
purple102712673purple
puzzlers18295143puzzlers
riddle83915713riddle
riffle124210233riffle
rifle85518333ri_fle
rile45650533ri__le
rille55728733ri_lle
rimple103814583rimple
ripple103413913ripple
sickle124418323sickle
sidle65124033si_dle
simile83115633simile
simple104315173simple
single74520603single
sizable1839893sizable
size135630963si_z_e
sizzlers16274753sizzlers
sozzled16265183sozzled
spatzle1834573spatzle
spicule11269933spicule
spile75230083spi__le
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
swizzled2053013swizzled
swizzler1963223swizzler
swizzles1953783swizzles
tazze1339573tazz_e
teazle15329553teazle
tickle124616743tickle
tile45451443ti__le
tingle74319053tingle
tinkle103714453tinkle
tipple103411913tipple
title54721073ti_tle
tittle63613323tittle
tizzies15287893tizzies
tizzy16548893tizz_y
touzle15429003touzle
unpuzzle1842303unpuzzle
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.1401276364.3
2DLD Change Limit1127162966.54617219.1
3Display Results2962960.0933182.8
 (SQL Overall)1786912966.77926359.5
 
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.