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

220 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
geld6582843(None) 
eld46733791_eld
ged57044531ge_d
geed65435501geed
gel45642431gel_
gelds75118341gelds
gelid74916971gelid
gels56836101gels
gelt56448011gelt
gild65526511gild
gled65631141gled
gold65430161gold
held85330401held
meld75830471meld
veld85323201veld
weld84727731weld
yeld811423871yeld
aged67334252age_d
auld54125362auld
bald76432902bald
bead75937922bead
bed67950622be_d
bel57148462bel_
bell66237182bell
bels66142492bels
belt65754032belt
bend76435262bend
bield84614652bield
bled75729312bled
bold75432812bold
cel56040552cel_
cell65031722cell
cels65534972cels
celt65646712celt
cold77338772cold
dead65434242dead
deed65340902deed
del46752752del_
dele56843082dele
deled75326542deled
delf85436572delf
deli55631292deli
dell56938202dell
dels56745472dels
delt57855272delt
ed38645182_e_d
eel37946842eel_
eels46536742eels
eely77725212eely
egad64215412egad
el26745292_el_
elds56324852_elds
elf66138522_elf
elk76726122_elk
ell36735682_ell
elm57531742_elm
els37645722_els
end46834352_end
fed76548352fe_d
feed84538902feed
felid94717172felid
fell76833072fell
felt75146932felt
fend84832972fend
feod815523002feod
feud86523022feud
field95015322field
fjeld16465582fjeld
fled85429772fled
fold86528942fold
gad57556652g_ad
gaed66031512gaed
gal46055512gal_
gala55635162gala
gale56347322gale
gall56335992gall
gals57946502gals
gaud67025432gaud
gear55934972gear
geck115721992geck
geds66730812geds
gee45359202ge_e
geek95327022geek
gees55647882gees
geez146424862geez
gelada837622gelada
gelded94512112gelded
gelder84613712gelder
gelee63626982gelee
gelled84718892gelled
gelts65924612gelts
gem66840222ge_m
gems75329112gems
gen45950512ge_n
gene56237222gene
gens55740072gens
gent56954392gent
genu55929072genu
geode7412592geode
geoid74215752geoid
germ75428962germ
gest56149132gest
get47467462ge_t
geta56627442geta
gets55442482gets
geum75424552geum
gey75738302ge_y
gid57047262g_id
gied64631982gied
gilds75417522gilds
gill56336182gill
gilt56348542gilt
gird65424992gird
glad65624012glad
glede75517832glede
gleds75417892gleds
glee55239062glee
gleed75320572gleed
gleg66219802gleg
glen56027202glen
gley85724652gley
goad66830982goad
god57449792g_od
golds75421312golds
golf85731182golf
good66531802good
gowd96519982gowd
grad66829862grad
greed75125692greed
grid65829612grid
guid66022822guid
guild75312752guild
gul45832792gul_
gulf84929422gulf
gull54828452gull
gulp75521362gulp
guls55930852guls
head87137172head
heed86437602heed
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
herd84933062herd
hold86235062hold
jeed125428502jeed
jell117125872jell
kelp105322802kelp
kelt85343192kelt
lead56038852lead
led46254552le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146742me_d
meed74934702meed
mel56047482mel_
melds84822382melds
mell64935612mell
mels65941532mels
melt65752892melt
mend75334022mend
mild75330852mild
mold76034332mold
need54934152need
nerd56624942nerd
ogled75915962ogled
old47033462_old
ped66751522pe_d
peed76239182peed
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pend75934532pend
pled75231432pled
read55942532read
red46755802re_d
redd66323172redd
reed55549622reed
rely75428952rely
rend56136572rend
seed55549482seed
sel38253322sel_
self75138292self
sell45840612sell
sels46345982sels
send55237292send
sild55030582sild
sled55334372sled
sold54837412sold
ted46446562te_d
teed55439262teed
tel35647902tel_
tela45532972tela
tele45040872tele
tell44934702tell
tels46841692tels
tend56433772tend
told56132202told
vela75725542vela
velds95615582velds
veldt94819862veldt
vend86626422vend
weald95615022weald
wed75843622we_d
weed85637512weed
welds94719162welds
well75832042well
welt75547862welt
wend85330452wend
wield95213912wield
wild85126512wild
wold85429072wold
yald86920602yald
yelk115320002yelk
yell76028322yell
yelp95621352yelp
yield9519692yield
zed135431172ze_d

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.0762351197.4
2DLD Change Limit298722200.87634100.5
3Display Results2202200.0603666.7
 (SQL Overall)1786912201.012176572.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.