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

310 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
sizzle1430961(None) 
fizzle17369711fizzle
mizzle16279991mizzle
pizzle16279491pizzle
sizzled16367881sizzled
sizzler15266861sizzler
sizzles15349631sizzles
swizzle1854101swizzle
zizzle13247311zizzle
dazzle1536852dazzle
drizzle16285912drizzle
fizzled19357272fizzled
fizzles18339062fizzles
frizzle18367042frizzle
grizzle16306112grizzle
guzzle15297912guzzle
mizzled18327632mizzled
mizzles17329492mizzles
mizzly19256102mizzly
muzzle16319392muzzle
nozzle14236632nozzle
nuzzle14298082nuzzle
pizzles17329272pizzles
puzzle16318602puzzle
sickle124418322sickle
sidle65124032si_dle
simile83115622simile
simple104315172simple
single74520602single
sizable1839892sizable
size135630962si_z_e
sizzlers16274752sizzlers
sozzled16265182sozzled
swizzled2053012swizzled
swizzler1963222swizzler
swizzles1953782swizzles
zizzled15315852zizzled
zizzles14307092zizzles
aisle55223193ai_sle
azole145118033_azole
bible95119413bi_ble
bile66147173bi__le
bindle94516263bindle
birle75023633bi_rle
bize155926283bi_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
fimble133611743fimble
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
mile66352563mi__le
mille75029133mi_lle
mingle93518783mingle
mizzen16447953mizzen
muzzled18267753muzzled
muzzler17257943muzzler
muzzles17299683muzzles
nibble103713283nibble
nickle123814483nickle
niggle83612823niggle
nimble103412933nimble
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
sable74732163s_able
saddle83915493saddle
sale44959703s__ale
sample104215013sample
scale74629143s_cale
sedile73517233sedile
seizable1938723seizable
seize143819503seiz_e
seizure1634683seizure
selle54428313s_elle
semple103212753semple
senile63420213senile
settle63915663settle
shale85332833s_hale
shingle117711273shingle
sial45938833si_al_
sials54227243si_als
sibyl1037113sibyl_
sibyls1135303sibyls
sice65545593si__ce
sickee124622223sickee
sickie123715743sickie
sickled144713433sickled
sickles133417543sickles
sickly153110483sickly
side55444483si__de
sidhe95315103si_dhe
sidled84215173si_dled
sidler74716963si_dler
sidles74721153si_dles
siege66718443si_ege
sieve84918843si_eve
sigil63515503sigil_
sigils73912363sigils
sigla64515203si_gla
signee73617233signee
sike87138783si__ke
silage72715303silage
silane62718053silane
sild55030583si__ld
silex123417413si__lex
silicle937753silicle
silk85529323si__lk
silkie103313403silkie
sill45545153si__ll
siller64026053si_ller
sills55135983si_lls
silly84527613si_lly
silo46037913si__lo
silt46558193si__lt
silvae92811093silvae
similes92915233similes
simnel857023simnel
simpler112910863simpler
simples113014943simples
simplex18256393simplex
simply133010523simply
since75024173si_nce
sine46560623si__ne
singe65731133si_nge
singled93914683singled
singles83520433singles
singlet84120113singlet
singly104015853singly
sipe67341043si__pe
sire46150413si__re
siree55238813si_ree
sirree64017333sirree
sisal54217733sisal_
sisals63013573sisals
site47052413si__te
sixte126216583si_xte
sizably2136613sizably
sizar145214993si_zar
sizars154812623sizars
sizeable1937113sizeable
sized155519243si_zed
sizer145521813si_zer
sizers155215813sizers
sizes146727763si_zes
sizier1514813393sizier
sizing163616443sizing
sizy164816393si_z_y
sizzling17225783sizzling
skiable1338883skiable
skiffle17225203skiffle
skittle1135523skittle
smaze165012933smaz_e
smile74823913s_mile
sniffle13287643sniffle
sniggle9316833sniggle
snoozle16305903snoozle
socle7419573s_ocle
sole46053673s__ole
sozine15712343sozine
spale74929213s_pale
spatzle1834573spatzle
spicule11269933spicule
spile75230083s_pile
spindle103210093spindle
spinule9299993spinule
spittle937923spittle
stable83921643stable
stale55637103s_tale
staple84415823staple
stele55026843s_tele
stickle132410973stickle
stifle93611903stifle
stile54931573s_tile
stipple1146623stipple
stipule936723stipule
stole54928813s_tole
style85519363s_tyle
suable83920553suable
subtle82113433subtle
suckle124015963suckle
supple10410203supple
swale85221593s_wale
swindle11389183swindle
swingle113510563swingle
swiple11379233swiple
swipple1444633swipple
swizzlers2052193swizzlers
tazze1339573tazz_e
teazle15329553teazle
tickle124616743tickle
tile45451443ti__le
tingle74319053tingle
tinkle103714453tinkle
tipple103411913tipple
title54721073ti_tle
tittle63613323tittle
tizzies15287893tizzies
tizzy16548893tizz_y
touzle15429003touzle
viable111613773viable
vile76139803vi__le
virile9313433virile
vittle94711753vittle
vizsla1833703vizsla
widdle113814843widdle
wiggle113713013wiggle
wile75944373wi__le
wimble133211913wimble
wimple133611363wimple
windle104617953windle
winkle133812833winkle
wintle94014603wintle
winze175014853winz_e
wizzen17387203wizzen
wizzes175110773wizzes

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.1431249587.4
2DLD Change Limit1127163105.12322002.0
3Display Results3103100.0933333.3
 (SQL Overall)1786913105.35933344.1
 
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.