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

232 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
duelli76700(None) 
duello756781duello
celli76717692_celli
deli55631292d_e_li
dell56938202d_ell_
dells66630942d_ells
delly96023872d_elly
dually103210062dually
duel56729702due_l_
dueled84813662dueled
dueler74213682dueler
duelled9359752duelled
dueller8329832dueller
duelling103410732duelling
duellist986332duellist
duellos845762duellos
duels65619232due_ls
dull56430442du_ll_
dulls64523742du_lls
dully94921632du_lly
dwell9519852dwell_
dwells10417712dwells
muesli835182muesli
nielli636302nielli
nucelli944722nucelli
ocelli836842ocelli
quell144311422quell_
quells15359692quells
bell66237183_bell_
belle75827833_belle
bells76432163_bells
belly104625493_belly
bull65634873bu_ll_
bulla74620563bu_lla
bulls75629573bu_lls
bully105124813bu_lly
ceili75814793_ceili
cell65031723_cell_
cella75420313_cella
cello74919583_cello
cells75428063_cells
chilli114312773chilli
cruelly1236553cruelly
cull65929643cu_ll_
cullis84115993cu_llis
culls75425813cu_lls
cully105520463cu_lly
culti76317253cu_lti
cumuli1036273cumuli
dally95324743d_ally
deal56347413d_eal_
deals65435343d_eals
dealt65234283d_ealt
deeply1257013deeply
defi86321493d_e_fi
deil56231623d_eil_
deils65722863d_eils
del46752753d_e_l_
delay94820633d_elay
dele56843083d_e_le
deled75326543d_eled
deles65139253d_eles
delf85436573d_e_lf
delfs94918673d_elfs
delft95623323d_elft
delis64928543d_elis
dellies83622213d_ellies
dels56745473d_e_ls
delt57855273d_e_lt
delta66117773d_elta
deltic9312503d_eltic
delts65731793d_elts
delve96018263d_elve
deni56929393d_e_ni
devil94714733d_evil
diel59034603die_l_
dill55239973d_ill_
dills65530973d_ills
dilly94923783d_illy
dolci84912603d_olci
doll56632493d_oll_
dolls66126923d_olls
dolly96125203d_olly
drill64718263drill_
drills74414203drills
droll65415403droll_
drolls75312393drolls
drolly105411673drolly
dual55928173du_al_
duals65620083du_als
ducal84816423ducal_
ducally13257413ducally
duci76422623du__ci
due45249863due___
duelers83412053duelers
dueling93614543dueling
duelist8511413duelist
duellers9268223duellers
duellists1053753duellists
duende836923duende
duenna734593duenna
dues56045503due__s
duet56446263due__t
dueted84113593dueted
duets65323883due_ts
duffle13368533duffle
dui46433383du___i
dulia61014983du_lia
dulled84719423dulled
duller74017703duller
dulling93418273du_lling
dullish1148743du_llish
dulse65415043du_lse
duly85323033du__ly
dumbly14399603dumbly
dunlin739723dunlin
duolog835803duolog
duomi8310133du_omi
duple85315863du_ple
duplex16386973duplex
dural64923893dural_
duxelles1643963duxelles
dwelled12337593dwelled
dweller11297273dweller
dwelling13368413dwelling
dwelt94316523dwe_lt
elhi7612403__elhi
ell36735683__ell_
ells46431353__ells
fell76833073_fell_
fella84918653_fella
fells85327383_fells
felly114922803_felly
fuel76824733fue_l_
fueled104913603fueled
fueler94313933fueler
fuelled11369193fuelled
fueller10279963fueller
fuelling123410153fuelling
fuels87117353fue_ls
full75229153fu_ll_
fulls84623523fu_lls
fully114820863fu_lly
fumuli1135263fumuli
fusilli1044233fusilli
gull54828453gu_ll_
gulls65222983gu_lls
gully94020683gu_lly
hell75637893_hell_
hello86522983_hello
hells85032043_hells
hull75428783hu_ll_
hullo84417453hu_llo
hulls84923563hu_lls
jell117125873_jell_
jello126716273_jello
jells125522163_jells
jelly154218253_jelly
kelly124617023_kelly
knell94210923knell_
knells10439253knells
kvell12436693kvell_
kvells13346613kvells
lull44225763lu_ll_
lulls54119653lu_lls
mell64935613_mell_
mells75031333_mells
mueslis935493mueslis
mull65128803mu_ll_
mulla74317113mu_lla
mulls75124153mu_lls
nellie63614813_nellie
nelly84618813_nelly
niello636603niello
nuclei857723nuclei
null45125313nu_ll_
nulls55019983nu_lls
obeli73711933obe_li
paella8410913paella
phalli1148263phalli
pueblo1035553pueblo
puli65527623pu__li
pull64731663pu_ll_
pulls74425053pu_lls
quelea1547303quelea
quelled17279273quelled
queller16289293queller
quelling18259793quelling
quill148413763quill_
quillai1644993quillai
quills153811843quills
quoll14379493quoll_
quolls15327303quolls
rubella9146523rubella
sell45840613_sell_
selle54428313_selle
sells55134433_sells
shell84424123shell_
shells94319523shells
shelly124414463shelly
skell94915833skell_
skells105013783skells
smell74916233smell_
smells83914743smells
smelly114110353smelly
snell54517303snell_
snells64614203snells
spell75020303spell_
spells84617683spells
stelai63912563stelai
stella63612973stella
sulci7615053su_lci
sully84622893su_lly
swell84815983swell_
swells93913983swells
tell44934703_tell_
tells55828943_tells
telly84920823_telly
teloi54217383_teloi
thalli958913thalli
trellis739873trellis
tufoli933973tufoli
tuille63012643tuille
tulle54019933tu_lle
tumuli835933tumuli
villi86517853_villi
well75832043_well_
wellie92814913_wellie
wells85426193_wells
welly114620013_welly
yell76028323_yell_
yells85821943_yells

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.1561145455.1
2DLD Change Limit1127162326.64016975.3
3Display Results2322320.0802900.0
 (SQL Overall)1786912326.87625987.6
 
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.