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 “dunes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

303 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
dunes6533217(None) 
denes65639721denes
dines66449151dines
duces86327471duces
dudes75424371dudes
dues56045501du_es
dukes105023471dukes
dunces95215751dunces
dune56137581dune_
dungs75821971dungs
dunks105621191dunks
duns55140431dun_s
dunts65828411dunts
dupes86425931dupes
dures65635921dures
dynes95917581dynes
lunes55337771lunes
runes55530221runes
tunes55332191tunes
acnes75922622acnes
anes45255932_anes
aunts55227632aunts
aures55137092aures
banes74945582banes
benes75536232benes
bines76946792bines
bones76446532bones
bunas75126572bunas
bunds85523542bunds
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
buses75936012buses
butes714535872butes
canes75350372canes
cines75239682cines
cones76457422cones
cubes95028162cubes
cues65438982cu_es
cukes115422092cukes
cunts76125122cunts
cures75645432cures
cutes79438322cutes
daces85030682daces
dales66439742dales
dames85435852dames
dances95120652dances
dangs75623212dangs
dans56748152dan_s
dares66146702dares
dates65639152dates
daubes94913702daubes
daunts75014082daunts
dazes155024142dazes
dees56356632d_ees
dekes105224452dekes
deles65139252deles
demes86032692demes
dene56643412dene_
denies74729642denies
dens55945072den_s
dense65923502dense
dents65031802dents
deuces94015512deuces
dexes135224512dexes
dices86434242dices
dienes75719902dienes
dies55653532d_ies
dikes105831332dikes
dimes85833042dimes
dine55555342dine_
dined76431992dined
diner65632902diner
diners75525952diners
dinges83825422dinges
dings76331402dings
dinks105927952dinks
dinos65428062dinos
dins56652052din_s
dints67431312dints
dites66339152dites
dives95832402dives
does56554472d_oes
doges75630162doges
doles67843752doles
domes85735562domes
donas65926472donas
done55747912done_
donee66931012donee
donees74519492donees
dongs76525812dongs
dons56048702don_s
dopes84935042dopes
doses65938502doses
dotes65836692dotes
douses74928932douses
doves94728152doves
dozes155226302dozes
drees65628522drees
dries64733672dries
drones75023432drones
drunks11427512drunks
drupes94912652drupes
druses75517252druses
duads76515342duads
duals65620082duals
dubs78432192du_bs
duce76933502duce_
ducks124823212ducks
ducts85319892ducts
dude65629672dude_
duded84417132duded
duds65530152du_ds
due45249862du_e_
duel56729702du_el
duels65619232duels
duendes938192duendes
dueness82310122dueness
duet56446262du_et
duets65323882duets
duffs125216622duffs
dufus94010812dufus
dugs614832282du_gs
duits65021882duits
duke95628102duke_
duked115218462duked
dulls64523742dulls
dulness8307982dulness
dulse65415042dulse
dulses73913652dulses
dumas85420432dumas
dumbs105915752dumbs
dumps105220102dumps
dun46545582dun__
dunam8313732dunam
dunams937832dunams
dunce86319262dunce
dunch115316262dunch
dunches133312582dunches
dung66328432dun_g
dunged95414692dunged
dungy104713642dungy
dunites8313592dunites
dunk96228572dun_k
dunked124315282dunked
dunker113616462dunker
dunkers123512192dunkers
dunned85015522dunned
dunner73913822dunner
dunness8298982dunness
dunnest83312262dunnest
dunt55746872dun_t
dunted84718502dunted
duos56728132du_os
dupe76630602dupe_
duped95118322duped
duper85519002duper
dupers94615602dupers
dups75929512du_ps
duras65727732duras
dure56341812dure_
dured75025402dured
duress74712062duress
durned84113172durned
durns64819872durns
duros65422692duros
durrs65519992durrs
dusks105317252dusks
dusts65923562dusts
duties74921902duties
duvet9321872duvet
duvets1039222duvets
dwines105013102dwines
dyes85331892d_yes
dykes135215572dykes
dyne85320932dyne_
dynel9569852dynel
dynels10536812dynels
educes94011952educes
ernes55224812ernes
esnes54817362esnes
fanes84639892fanes
fines86644262fines
fumes105224702fumes
funds94119252funds
funest94316862funest
funks125318912funks
funs75235732fun_s
fuses85628422fuses
fuzes175120222fuzes
genes65133092genes
gudes74520812gudes
gules64831042gules
gunks104517722gunks
guns55533482gun_s
hones88144492hones
hues75235232hu_es
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
janes124928122janes
jones125028182jones
jubes145420742jubes
jukes165319102jukes
junks164815972junks
jupes145218552jupes
jutes125125132jutes
kanes95529372kanes
kines95039142kines
kues86426782ku_es
kune85424582kune_
lanes54946792lanes
lenes54738522lenes
lines57054572lines
lubes74727992lubes
luces75528432luces
ludes65728852ludes
lues45943552lu_es
luges65928752luges
lunas55025012lunas
lune47140492lune_
lunet56835422lunet
lunets66914762lunets
lunges76123422lunges
lungs65223882lungs
lunies64723012lunies
lunks94822452lunks
lunts55826902lunts
lures56138532lures
lutes55836662lutes
luxes124921502luxes
manes76648962manes
mines75651952mines
mules75034292mules
munis75022002munis
muns65535922mun_s
mures75937222mures
muses75134302muses
mutes75033782mutes
nenes55329672nenes
nines55937342nines
nones55639132nones
nudes64723292nudes
nukes95418122nukes
nuns45228232nun_s
ones46146532_ones
ounces83617772ounces
panes76148692panes
penes75839222penes
pines76048862pines
pones74547042pones
prunes83419062prunes
pubes94423402pubes
puces94924632puces
pukes114523022pukes
pules74538812pules
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pun_s
punts75828002punts
puses75532202puses
rubes74928412rubes
rues46044482ru_es
rules55234252rules
rune45236302rune_
rungs611819402rungs
runs46438082run_s
runts55927632runts
ruses56136582ruses
sanes55649072sanes
sines55954822sines
sones55444142sones
sues46247652su_es
sunns55017352sunns
suns45841902sun_s
supes75628302supes
tines54848422tines
tones56048662tones
tubes74826452tubes
tules54532792tules
tunas54224122tunas
tune45635862tune_
tuned64622312tuned
tuner56022682tuner
tuners64417342tuners
tungs65520632tungs
tuns45138662tun_s
tuxes124316042tuxes
tynes85920302tynes
ukes86122812_ukes
uns35936762_un_s
uses44931112_uses
utes45930882_utes
vanes85130982vanes
vines85137642vines
wanes85040882wanes
wines85546862wines
yules84521582yules
zines145232652zines
zones145528042zones

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit538003031.65632487.9
3Display Results3033030.0803787.5
 (SQL Overall)1786913032.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.