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

400 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
dite5554755(None) 
bite66546991bite
cite65640341cite
date56443321date
dice75841891dice
die46759651di_e
diet57357531diet
dike95935761dike
dime76237641dime
dine55555331dine
dire56644141dire
dit47071331dit_
dita56032521dita
dites66339151dites
dits56450521dits
ditz146929511ditz
dive85634771dive
dote55442881dote
gite55438611gite
kite85338231kite
lite47054541lite
mite66249401mite
nite45943581nite
rite45849451rite
site47052411site
wite75443271wite
adit56443652adit_
adits66523712adits
aide56044992aide
ait38093902ait_
aits46355532aits
ante46538902ante
ate37059242_ate
axite125218252axite
bate66552422bate
bice86235552bice
bide76041472bide
bike106532592bike
bile66147172bile
bine66650852bine
bise66437092bise
bit57070892bit_
biter75030032biter
bites75641172bites
bits66148152bits
bitt65545802bitt
bize155926282bize
blite76225352blite
boite74426322boite
bute66739672bute
byte96521812byte
cate66254592cate
cete64934782cete
cine66242942cine
cire65836372cire
cited84421952cited
citer74827322citer
cites74435582cites
city95122622city
cote66648732cote
cute66440452cute
dace76934922dace
dacite91115882dacite
dale55643982dale
dame77140312dame
dare55848862dare
data56026652data
dated75530992dated
dater65332312dater
dates65639152dates
dato56129942dato
daze147327232daze
de37049542d__e
dee47665822d_ee
deet57356582deet
deice84320032deice
deity94316772deity
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
dere56845902dere
deter65028042deter
dial55935062dial
dib65746932di_b
dibs76233672dibs
diced95824682diced
dicer85426422dicer
dices86434242dices
dicey114819332dicey
dick116432382dick
dicta84915632dicta
dicty115116292dicty
did56850512di_d
didie74120562didie
dido66528192dido
didy99121502didy
died66137852died
diel59034602diel
diene65720132diene
dies55653522dies
dieted83115492dieted
dieter73516772dieter
diets66026642diets
dif76846892di_f
diff116228832diff
difs86027322difs
dig57544472di_g
digs66036052digs
diked115024682diked
diker105524552diker
dikes105831332dikes
dikey135116422dikey
dilate73220692dilate
dill55239972dill
dilute72911802dilute
dim68146492di_m
dimer85625602dimer
dimes85833042dimes
dims75435022dims
din46459462di_n
dined76431992dined
diner65632902diner
dines66449152dines
ding66940952ding
dinge75627302dinge
dink97137802dink
dino56036752dino
dins56652042dins
dint56759052dint
dinted84419842dinted
dints67431312dints
diode74716112diode
diol57329132diol
dip67848982di_p
dips75536912dips
dipt77339322dipt
direr64927072direr
dirge75117072dirge
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
dirts66824462dirts
dirty95617802dirty
dis46459892di_s
disc76123232disc
dish86328332dish
disk96625832disk
disme85716242disme
diss56434482diss
ditas65923672ditas
ditch115015092ditch
dither104417682dither
ditsy95612562ditsy
ditto65315602ditto
ditty95019292ditty
ditzes163212422ditzes
ditzy186513282ditzy
diva85920882diva
dived106321372dived
diver94827802diver
dives95832402dives
dizen155214932dizen
doe47361952d_oe
doge66233802doge
doit56347852doit_
doited85016632doited
doits66223672doits
dole56550002dole
dome77240732dome
done55747912done
dope76038892dope
dore56353302dore
dose56442432dose
dot47573182dot_
doted75227072doted
doter65428622doter
dotes65836692dotes
doth86225712doth
dots55647662dots
doty86128222doty
dove85131562dove
doze145829082doze
dree56638322dree
drive95318002drive
duce76933502duce
dude65629662dude
due45249862d_ue
duet56446262duet
duit56241582duit_
duits65021882duits
duke95628102duke
dune56137582dune
dunite7315012dunite
dupe76630602dupe
dure56341812dure
duty85321452duty
dwine95616142dwine
dye75334842d_ye
dyke126418182dyke
dyne85320932dyne
edile64819492edile
edit54934862edit_
edited83913672edited
edits65819032edits
eide55832232eide
elite56230182elite
endite73817592endite
evite85317682evite
fate75444282fate
fete75734922fete
fice95737112fice
fie67152442fi_e
fife106027702fife
file75446642file
fine75147952fine
fire76245592fire
fit66365452fit_
fits76043462fits
five107629742five
flite85424962flite
gate55746572gate
gibe75927772gibe
gie47149542gi_e
git46266052git_
gites65630182gites
gits55744592gits
give85829352give
hate78450172hate
hide85134622hide
hie67652702hi_e
hike116830392hike
hire75538962hire
hit66569192hit_
hits75545132hits
hive106029672hive
hyte109018942hyte
ice56737242_ice
idle55423762idle
indite73520312indite
ire36943172_ire
it28455682_it_
item65620382_item
its35538832_its
jete115927252jete
jibe136323382jibe
jive146123592jive
jute115327892jute
kibe106523432kibe
kike76524782kike
kine85643422kine
kit78559872kit_
kited105120092kited
kiter95523212kiter
kites95432542kites
kith115826352kith
kithe125917452kithe
kits86441762kits
kyte117017762kyte
late47560482late
lice66045062lice
lie38264522li_e
life75433732life
like86040842like
lime66244932lime
line46965572line
lipe66839732lipe
lire47845292lire
lit39377312lit_
liter54736342liter
lithe84922012lithe
litre55421462litre
lits46252492lits
litu47631562litu
live76540992live
lute46341012lute
mate65154212mate
mete64438132mete
mice87442222mice
mike105535282mike
mile66352562mile
mime85736392mime
mine67256152mine
mire66748222mire
mise66043572mise
miter75734792miter
mites75141802mites
mitre75522422mitre
mitt66145482mitt
mity95528202mity
mote67048082mote
mute65136872mute
nice65534712nice
nide55535782nide
nine45842172nine
nit37065942nit_
niter55028972niter
nites55736342nites
nitre57519682nitre
nits45741642nits
nixe115722022nixe
note46239962note
pate65350462pate
pice84641092pice
pie55457402pi_e
pike106335212pike
pile65649692pile
pine67755712pine
pipe86434432pipe
piste75824602piste
pit56471922pit_
pita65436432pita
pith95432692pith
pits66348742pits
pity96031932pity
podite93315352podite
quite144621462quite
rate45458762rate
rete44944132rete
rice64942912rice
ride55945122ride
rife74632322rife
rile45650532rile
rime65138882rime
ripe66038922ripe
rise45945232rise
rites54442552rites
ritz135129982ritz
rive75537722rive
rote46249022rote
sate45556102sate
sice65545592sice
side55444482side
sike87138782sike
sine46560622sine
sipe67341042sipe
sire46150412sire
sit35877752sit_
sited65130742sited
sites56045432sites
sith75435152sith
sits45050202sits
sixte126216582sixte
size135630962size
skite95120042skite
smite75224862smite
spite75430662spite
suite54829562suite
tate44748602tate
tide55237372tide
tie36557532ti_e
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tire46143352tire
tit36771042tit_
titer55430612titer
tithe85319702tithe
titi47130612titi
title54721072title
titre54619392titre
tits46145032tits
tote46643672tote
trite54730032trite
unite54828382unite
ute35335882_ute
vibe95124492vibe
vice95732852vice
vide85432752vide
vie65447632vi_e
vile76139802vile
vine75643682vine
vise75632672vise
vita75828522vita
vitae84217632vitae
vive105426622vive
vote74728622vote
white114920302white
wide85235402wide
wife105228022wife
wile75944372wile
wine74953422wine
wipe94830282wipe
wire75839812wire
wise75737342wise
wit66563772wit_
wited94727142wited
wites85536962wites
with105730472with
withe115220232withe
wits76044872wits
wive105931752wive
write85522832write
wyte106018642wyte
yipe96722172yipe
zine137036152zine
zit126049992zit_
ziti136022372ziti
zits136030292zits

Search took 2 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 Filter178691298720.0931921408.6
2DLD Change Limit298724000.90632971.3
3Display Results4004000.0934301.1
 (SQL Overall)1786914001.092163636.4
 
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.