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

156 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
nakeder125436(None) 
fakeer13378742fake_er
naked105320852naked__
nakedest1345472nakedest
nakedly1534402nakedly
needer73614952n_eeder
wakener1446912wakener
abider95314463_abider
acceder1235353acceder
adder75419593_a_dder
aedes64625143_a_edes
aider65431133_a_ider
akee85936813_ake_e_
akees96119243_ake_es
akene95818663_akene_
akenes104817343_akenes
alder65421913_a_lder
ameer75618983_ame_er
amender10349613_amender
arider74717743_arider
aulder7511453_aulder
awakener1543433awakener
badder103817513ba_dder
baked126130773baked__
baker115629543bak__er
balder95318863ba_lder
bander93928223ba_nder
bleeder10359643bleeder
breeder103210043breeder
caked126128623caked__
cakier123115243cak_ier
calender1138273calender
caperer113013403caperer
carder94524183ca_rder
career85822243care_er
caterer92815943caterer
ceder85322233__ceder
cheder125113493_cheder
damneder1243763damneder
dander811222993da_nder
darkener1335993darkener
darneder1033983darneder
daunder9348893daunder
eagerer8248823eagerer
enameler1045883enameler
fader94421513fa__der
faked135225483faked__
fakeers14446673fake_ers
faker124824593fak__er
feeder103513843_feeder
gadder93714713ga_dder
gander84322763ga_nder
hakeem15407383hake_em
hander104526433ha_nder
hankerer15248233hankerer
harder105022403ha_rder
harkener1537573harkener
heder95623633__heder
heeder104216043_heeder
impeder12438533impeder
jaeger14397193ja_eger
jaggeder1842783jaggeder
labeler92310183labeler
ladder84617623la_dder
lader65633723la__der
lakebed1434783lakebed
laked105731123laked__
laker95432873lak__er
lakier104716273lak_ier
lander74028483la_nder
larder73720973la_rder
lauder73815013la_uder
launder8309143launder
laveer94110423lave_er
lavender1235143lavender
lieder74912323_lieder
madder103515593ma_dder
makeover17113353makeover
maker114127813mak__er
marketer1437383marketer
maunder10328683maunder
nabber104913543na_bber
nadir61012973na__dir
nagger84016123na_gger
naggier9309153naggier
naiades838213naiades
nailer64119363na_iler
naiver94311353na_iver
nakedness1445043nakedness
naled65525053naled__
naleds7469133naled_s
named85223063named__
namer75622103na__mer
nankeen1135043nanke_en
napper103718283na_pper
nappier114411173nappier
narked114116743narked__
nastier74115293nastier
natter64420743na_tter
nattier73614623nattier
needed84114443n_eeded
needers84111903n_eeders
needier84010623n_eedier
needler8388893n_eedler
never86218643n__ever
newer85717463n__ewer
nodder84811943n_odder
nuder66416833n__uder
nuked104014183nuked__
oakier104011393oak_ier
padder103415493pa_dder
pander93725523pa_nder
paperer113111903paperer
parader103914863parader
raggeder1143263raggeder
raider74318743ra_ider
raked105831423raked__
rakee96031173rake_e_
rakees104516973rake_es
raker94529793rak__er
rapider1067903rapider
raveler104212463raveler
ravener104110733ravener
sadder82916973sa_dder
saker95132023sak__er
sander74828533sa_nder
scareder1135783scareder
seceder10329573seceder
seder64826753__seder
seeder74320773_seeder
skewer13519603_skewer
snaked115017593snaked__
snakier112810003snak_ier
speeder103811073speeder
takeover15113693takeover
taker95229003tak__er
taperer92511793taperer
tireder837703tireder
vakeel1335193vake_el
wadder114215483wa_dder
wader95325363wa__der
wagerer11328493wagerer
waked135626753waked__
wakened1546873wakened
wakeners1535843wakeners
waker125526593wak__er
wander104423713wa_nder
warder104020273wa_rder
waterer103314073waterer
waverer13319523waverer
weakener1534913weakener
weeder103315513_weeder
wickeder1843983wickeder
yakker12405533yak_ker
yarder103813973ya_rder
zander163417113za_nder

Search took 9 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 Filter1786911340270.1431249587.4
2DLD Change Limit1340271568.00016753.4
3Display Results1561560.0463391.3
 (SQL Overall)1786911568.18921820.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.