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

485 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
laddie8371317(None) 
baddie104114031baddie
caddie104316441caddie
laddies93715051laddies
waddie114013321waddie
addle74318352_addle
baddies114017872baddies
caddice13327732caddice
caddied123710562caddied
caddies113718382caddies
caddis104613372caddis
cuddie104011172cuddie
daddies103414942daddies
daddle94214282daddle
duddie9348862duddie
faddier1237782faddier
gaddi85211632gaddi_
gaddis94211372gaddis
kiddie12359392kiddie
ladder84617622ladder
laddish12299722laddish
lade56345982la_d_e
ladies75124882la_dies
ladle66320442la_dle
lambie103213662lambie
lardier83518342lardier
lassie64917742lassie
lyddite1243332lyddite
paddies113715722paddies
paddle104615142paddle
pardie96021442pardie
raddle84816172raddle
saddle83915492saddle
waddied13358562waddied
waddies124214752waddies
waddle114715302waddle
widdie113410732widdie
zaddik2134242zaddik
abide86223703_abide
adage7414053_adage
add510132363_add__
addax1435993_addax
added84918433_added
adder75419593_adder
addible11236063_addible
addict10711203_addict
adding93914963_adding
addled94112513_addled
addles84216603_addles
adds67622453_add_s
adduce1076453_adduce
adieu6417423_a_dieu
adit56443653_a_dit
admire949933_admire
admit8319493_admit
admix1557723_admix
adobe84814703_adobe
adore65723663_adore
adoze155713833_adoze
advice12107883_advice
advise10139223_advise
adze1412820573_a_dze
aedile73716653_aedile
aedine73218393_aedine
aerie54634603_aerie
aggie73415013_aggie
aide56044993_aid_e
aldose7311093aldose
aldrin7311243aldrin
alkie95520033_alkie
alodia71112453alodia
amide86128473_amide
amie66339843_a_mie
asdic83814093_asdic
aside65122083_aside
audile73315303_audile
audio62917103_audio
audit62527883_audit
azide155617163_azide
badder103817513badder
baddy125016023badd_y
bade75140883ba_d_e
badge94819683ba_dge
baggie102912193baggie
bailie83818363bailie
baldies105317703baldies
bandied114414303bandied
bandies104124863bandies
bandit93821133bandit
barbie105018353barbie
barde85330773bard_e
bardic11312923bardic
barmie103816393barmie
bawdier13378203bawdier
bawdies134613393bawdies
bawtie113812143bawtie
biddies113514493biddies
birdie94013783birdie
bladder11429153bladder
blade85923333bla_d_e
blastie92411393blastie
buddied12388003buddied
buddies113914353buddies
buddle104313083buddle
budgie104310343budgie
burdie93615023burdie
cabbie122913343cabbie
caddices14297853caddices
caddised13315893caddised
caddises12329353caddises
caddish143810123caddish
caddy125414023cadd_y
cade76443913ca_d_e
cadge94018783ca_dge
cadi75732173ca_di_
cadis84428493ca_dis
cadmic1338973cadmic
cadre85419013ca_dre
cammie124615293cammie
candid104517853candid
candied113816023candied
candies104125613candies
candle94321483candle
cannie83819363cannie
cardia9916373cardia
cardiae10713703cardiae
cardio9915673cardio
carnie84421093carnie
cattie85221013cattie
caudle93912913caudle
cavie104621593ca_vie
cladded12356923cladded
cladding1337143cladding
clade85821013cla_d_e
cladode1134613cladode
cloddier1234063cloddier
coddle104713853coddle
cuddies113313263cuddies
cuddle104414533cuddle
daddled113810743daddled
daddles104213803daddles
daddy116212563dadd_y
dandier93714573dandier
dandies94121443dandies
dandle84218093dandle
darkie113714013darkie
dassie74615573dassie
dautie72914693dautie
dawdle11399503dawdle
dawtie103011093dawtie
diddle94915213diddle
didie74120563_didie
die46759653___die
eddied9248323_eddied
eddies83313163_eddies
faddiest1338113faddiest
faddish15359003faddish
faddism14356723faddism
faddist12289643faddist
faddy135511623fadd_y
fade85736343fa_d_e
fadein1068843fadein
fadge104816993fa_dge
fadlike15318483fadlike
faerie93514683faerie
falsie93513853falsie
farcie114816473farcie
fiddle113613383fiddle
foodie104413843foodie
fuddies123211203fuddies
fuddle113312103fuddle
gadded103913173gadded
gadder93714713gadder
gadding113411453gadding
gadi66329723ga_di_
gadid85517373ga_did
gadids95611823gadids
gadis74825293ga_dis
gadje1457743ga_dje
gadoid9310443gadoid
gaudier938453gaudier
gaudies9311973gaudies
gawsie1038463gawsie
giddied11257713giddied
giddier10308723giddier
giddies103713363giddies
gladded11357453gladded
gladden10376313gladden
gladder10398313gladder
gladding1236303gladding
glade75121963gla_d_e
gladier93810993gla_dier
gladlier1034343gladlier
glassie8329493glassie
goodie83613993goodie
hackie154615623hackie
hade85440193ha_d_e
hadjee174111823hadjee
hadji16839873hadji_
hadjis17439633hadjis
halide103417993halide
handier113817443handier
handle104219293handle
hankie133915713hankie
hardier114721543hardier
hardies114923233hardies
hawkie163810093hawkie
heddle114211163heddle
hoddin11369933hoddin
hoodie105116133hoodie
howdie13349723howdie
huddle113712993huddle
indie63721463_indie
iodide84812923iodide
jade125325443ja_d_e
jadeite1546403jadeite
kaddish16317973kaddish
kadi96224823ka_di_
kadis105921063ka_dis
kiddies133412283kiddies
laari54415713laari_
labia75219003la_bia
labile8315213labile
lace66848473la__ce
lacier84020093la_cier
lactic10713493lactic
lacune8169673lacune
lad48165703la_d__
laddered1136743laddered
ladders94115173ladders
laded74232613la_ded
laden65022193la_den
ladened979053ladened
ladens74516233ladens
lader65633723la_der
laders74927763laders
lades65141273la_des
lading84227123lading
ladino73615123ladino
ladled85013483ladled
ladler74314933ladler
ladles74619543ladles
ladling92813393ladling
ladron73413323ladron
ladrone83611873ladrone
lads56549133la_d_s
lady86527153la_d_y
ladyish14287823ladyish
ladykin1543963ladykin
ladylike1634683ladylike
lagune7158633lagune
laic65931563la__ic
laicise939333laicise
laicize1838093laicize
laid56439143la__id
lain46146283la__in
lair45934153la__ir
laities7320343laities
lake85741603la__ke
lakier104716273la_kier
lambier113611633lambier
lambies113015103lambies
lame66849293la__me
lamia75324323la_mia
lamiae84817453lamiae
lanai5319573lanai_
lanais6316793lanais
lanate6421263lanate
lance75126723la_nce
land56337303land__
landau7310613landau
landed84619243landed
lander74028483lander
landing92819323landing
landler84113203landler
landline9311443landline
landmen1038553landmen
lands65426903land_s
landside10147443landside
lane45153323la__ne
langue71012173langue
lankier113711633lankier
lanose6313593lanose
lapdog1034443lapdog
lapides103012043lapides
lapin75222923la_pin
lapis76223153la_pis
lapse74917683la_pse
lard56742003lard__
larded84319093larded
larder73720973larder
lardiest93813883lardiest
larding92917873larding
lardlike1336503lardlike
lardon74415063lardon
lards65331863lard_s
lardy96119273lard_y
laree56036293la_ree
large65325463la_rge
lari45839153la_ri_
larine63927043larine
laris54737463la_ris
larkier113711523larkier
larvae938843larvae
lase46148513la__se
lassi56316853lassi_
lassies74420103lassies
lassis65216703lassis
late47560483la__te
lathe85626713la_the
lathi85417203lathi_
lathier10310833lathier
lathis95516173lathis
lati46438273la_ti_
latke94817093la_tke
latria62313583latria
latrine7715123latrine
latte55426303la_tte
lattice938433lattice
lattin64316223lattin
laud56527723laud__
lauded83812153lauded
lauder73815013lauder
lauding93211903lauding
lauds65618483laud_s
launce8469183launce
laurae64011663laurae
lauwine1036373lauwine
lavage1038263lavage
lave75642143la__ve
lawine93316463lawine
lawlike14137073lawlike
layin84720333la_yin
laze136235053la__ze
lazied164610653la_zied
lazier154214613la_zier
lazies154418783la_zies
leadier83212723leadier
ledge76519463l_edge
ledgier9458493ledgier
lezzie1435333lezzie
lidded93410243lidded
lidding103611423lidding
lie38264523l___ie
lindies8416583lindies
lipide93511063lipide
lode56240113l_od_e
lodge76520083l_odge
loggie84011993loggie
looie55624243l_ooie
loonie64216453loonie
louie55023513l_ouie
luckie123611413luckie
lude55331643l_ud_e
ludic82912803l_udic
luggie8318903luggie
lyddites1342583lyddites
madame1139853madame
madded113513553madded
madden103912523madden
madder103515593madder
madding123711993madding
maddish14289483maddish
made75440233ma_d_e
madre85720173ma_dre
magpie1139093magpie
mamie95826003ma_mie
mammie94313783mammie
mashie11315933mashie
mavie104722563ma_vie
meddle103312763meddle
middies113116153middies
middle103414983middle
muddied12339213muddied
muddier114110013muddier
muddies113513943muddies
muddle103414633muddle
nadir61012973na_dir
nandin7313033nandin
nannie63713223nannie
nappie104112263nappie
nardine82712573nardine
neddies92710703neddies
noddies93512043noddies
noddle83211363noddle
nudie65118673_nudie
oldie6415473_oldie
padded114113503padded
padder103415493padder
padding123412513padding
paddled123612023paddled
paddler113711553paddler
paddles113515633paddles
paddy125913593padd_y
padi76331783pa_di_
padis86227143pa_dis
padle84522343pa_dle
padre86018163pa_dre
padri85815163padri_
pandied113913443pandied
pandies104224503pandies
pandit93820753pandit
pantie84326473pantie
pardee93922023pardee
pardi85723953pardi_
pardine103616723pardine
pastie85525523pastie
pattie84020963pattie
peddle103512823peddle
perdie94718513perdie
piddle103514913piddle
plaudit1046253plaudit
puddle103914153puddle
qadi145621103qa_di_
qadis155917853qa_dis
radded94716493radded
radding103715003radding
raddled103812223raddled
raddles93615703raddles
radii64016413ra_dii
radio64922493ra_dio
radix134414593ra_dix
radome9511873radome
ramie75027823ra_mie
randier83618473randier
randies84225663randies
reddle83815913reddle
riddle83915713riddle
roadie72813803roadie
ruddier9338523ruddier
ruddle83414203ruddle
sadden83212403sadden
sadder82916973sadder
saddhu1133413saddhu
saddled103112033saddled
saddler93811963saddler
saddles95415743saddles
sade55544473sa_d_e
sadhe94815133sa_dhe
sadi55834643sa_di_
sadis64930853sa_dis
saltie63422423saltie
sandier84017843sandier
sardine83317393sardine
soddies92312853soddies
staddle9288093staddle
studdie9195273studdie
swaddle12276743swaddle
talkie103914443talkie
tammie104212683tammie
tardier859719993tardier
tardies84225863tardies
tardive1136893tardive
tassie66017023tassie
tattie64817513tattie
tawie84819813ta_wie
tawpie11339143tawpie
teddies92711283teddies
toddies93011993toddies
toddle85811033toddle
tsaddik1342073tsaddik
twaddle12245713twaddle
tzaddik2241763tzaddik
vadose1037963vadose
wadded124014173wadded
wadder114215483wadder
wadding133711943wadding
waddled133611643waddled
waddler124010793waddler
waddles124314843waddles
waddly14478723waddly
waddy135312993wadd_y
wade85237063wa_d_e
wadi86228173wa_di_
wadies105121203wa_dies
wadis95223963wa_dis
waffie15338563waffie
wallie93216803wallie
wandle105316663wandle
wedgie11428353wedgie
widdies123514033widdies
widdle113814843widdle
woodie103513613woodie
yabbie13308653yabbie
zaddick2442993zaddick

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 Limit1127164855.67319868.9
3Display Results4854850.1563109.0
 (SQL Overall)1786914855.98529856.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.