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

215 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
sardined1026866(None) 
sardine83317391sardine_
sardines92815561sardines
gardened1137002gardened
hardened1338612hardened
margined1237742margined
nardine82712572nardine_
pardine103616722pardine_
pardoned12189332pardoned
saddened1135342saddened
sained75424242sa__ined
shrined114112412shr_ined
sordine82515232sordine_
sordines92414072sordines
sprained1138432sprained
strained9412252strained
aedine73218393_aedine_
affined1436413_affined
alined75221403_a_lined
ariled75620323_ar_iled
arointed939003_arointed
arrived11127353_arrived
arsine64021043_arsine_
arsines73518813_arsines
audited939033_audited
bandied114414303bandi_ed
barded105426423bard__ed
barding113822893bardin_g
bargained1344953bargained
barned95623583bar__ned
basined10310003ba_sined
birdied11329433birdi_ed
brained103816103_brained
brined95118413_br_ined
burdened1236423burdened
cabined1239993ca_bined
caddied123710563caddi_ed
caddised13315893caddised
calcined1338743calcined
candied113816023candi_ed
carbine112918643carbine_
carbines123617533carbines
carded105424903card__ed
cardiae10713703cardiae_
cardinal1139563cardinal
carding113922433cardin_g
cardings123812633cardings
cardioid1247443cardioid
careened1139193careened
caried94528693car_i_ed
carline93923613carline_
carlines103521643carlines
carmine112918483carmine_
carmines123617863carmines
carried103717153carri_ed
cartoned111312833cartoned
cordoned12229613cordoned
darkened1435943darkened
darned85018483dar__ned
dined76431993___dined
drained93713253_drained
earned74818333ear__ned
earringed1144453earringed
ermined10410603_ermined
faradised14235913faradised
faradized23216313faradized
farded114518953fard__ed
farding123716743fardin_g
gained84617463ga__ined
gardener1037103gardener
gradine93317033gradine_
gradines103615253gradines
grained93814273_grained
groined92710813_groined
hardener1238883hardener
hardier114721543hardi_er
hardies114923233hardi_es
hardiness132310353hardiness
hardline12310273hardline_
hardwired1742873hardwired
harkened1637483harkened
harmine122816193harmine_
harmines132715143harmines
harried113815533harri_ed
jargoned1735233jargoned
ladened979053la_dened
larded84319093lard__ed
lardier83518343lardi_er
larding92917873lardin_g
larine63927043lar_ine_
machined1637303machined
maddened1334893maddened
marine84230403mar_ine_
mariner93315993mar_iner
marines93928013mar_ines
marline93320953marline_
marlines103818713marlines
marooned1138563marooned
married104715303marri_ed
martinet10319643martinet
narine63422553nar_ine_
ordained1035183_ordained
ordines83014903_ordines
pained95622853pa__ined
pandied113913443pandi_ed
pardie96021443pardi_e_
pardner10239473pard_ner
pardoner11189443pardoner
parodied1238333parodi_ed
parried103615723parri_ed
partied103516553parti_ed
patined105114783pa_tined
radioed939673ra_dioed
rained75024603__rained
ravined115411823ra_vined
reined74425523__reined
ruined74813323__ruined
sabine84020393sa_bine_
sabines94318483sa_bines
saddled103112033sa_ddled
sailed74327763sa__iled
sainted84114243sa__inted
saline65132703sa_line_
salines74029413sa_lines
sallied83316953salli_ed
saltine75018563saltine_
saltines82917793saltines
sandaled1039243sandaled
sanded84920613sand__ed
sandier84017843sandi_er
sandiness102111713sandiness
sanding93520603sandin_g
saned65636273sa___ned
sanidine939853sanidine_
sanidines1048043sanidines
sarcenet10413313sarcenet
sarcina9310733sarcin_a
sarcinae1047193sarcinae
sarcinas1039273sarcinas
sardana838643sardan_a
sardanas937813sardanas
sardining1137573sardining
sardius839553sardi_us
sardiuses1044753sardiuses
sardonic1147453sardonic
sardonyx1941453sardonyx
sarin55239253sar_in__
sarins63932623sar_in_s
sarkier113413313sarki_er
sarsenet8412943sarsenet
sarsnet7314813sar_snet
satinet7325283sa_tinet
savine94220283sa_vine_
savines104417633sa_vines
savvied1433803savvi_ed
screened1137403screened
scribed124510643scr_ibed
scried95817303scr_i_ed
scrived134511113scr_ived
seined74023063s__eined
sequined18105653sequined
serifed11811463ser_ifed
serine65432673ser_ine_
serines74229543ser_ines
serried82513963serri_ed
serviced1435613serviced
sharpened1544483sharpened
shined104620783s__hined
shrine94920053shr_ine_
shrines104618693shr_ines
shrived144712183shr_ived
skeined1236773s_keined
skydived2051563skydived
smartened1244263smartened
soddened1144643soddened
sordid83411163sordi__d
sordini8228963sordin_i
sordino8219443sordin_o
sorned74820043sor__ned
sortied83314103sorti_ed
sourdine936893sourdine_
sourdines1046743sourdines
spavined1434333spavined
spined95423943s__pined
splined105013113s_plined
springed123911323spr_inged
sprinted113411163spr_inted
stained84215343s_tained
strainer8512223strainer
stringed102911873str_inged
striped105214363str_iped
strived114713663str_ived
studied9268693studi_ed
sturdied10215963sturdi_ed
surmised1136863surmised
survived1534073survived
swarded1238153sward__ed
swarding1359003swardin_g
syringed13377583syr_inged
tardier859719993tardi_er
tardies84225863tardi_es
tardiness10229913tardiness
tardive1136893tardive_
tarried83914133tarri_ed
trained84117203_trained
trined74920713_tr_ined
turdine8310283turdine_
varied104817863var_i_ed
waddied13358563waddi_ed
warded115021043ward__ed
warding123918143wardin_g
warned104018913war__ned
yarded114714023yard__ed
yarding123413143yardin_g
yarned105514023yar__ned

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622157.12620511.1
3Display Results2152150.0932311.8
 (SQL Overall)1786912157.37524229.3
 
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.