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

335 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
ramtils93841(None) 
ramtil8311031ramtil_
camails11311752camails
pastils94416172pastils
rails55937402ra__ils
ramies84630462ram_ies
ramtilla1054732ramtilla
ramtillas1174192ramtillas
ratals64219582ra_tals
ratels64518212ra_tels
ratios64922672ra_tios
rattails837132rattails
remails94714562remails
actins86321103_actins
ails45654713_a__ils
amatols938183_amatols
ambits103713413_ambits
amias75831473_am_ias
amids85627513_am_ids
amies76837693_am_ies
amins75534323_am_ins
amirs75924923_am_irs
amis66445323_am_i_s
amiss75823073_am_iss
amities9317383_amities
amnios84912523_amnios
ampuls1098893_ampuls
amyls104512693_am_yls
anils56326723_a_nils
antics84621453_antics
antis55033313_anti_s
anvils9219713_anvils
aramids102810513aram_ids
archils12510533archils
arctics1138953arctics
argils75213623_argils
arils58732203_a_rils
armfuls1275013armfuls
armies85123693arm_ies
armpits1157133armpits
artels66216233_artels
artily92814713_artily
atilt54828473_a_tilt
attics84413283_attics
avails939693_avails
axils127217503_a_xils
bails75933523ba__ils
banties94324763banties
basils85717473ba_sils
bastile9313913bastile
bastiles10313353bastiles
batiks1239373ba_tiks
battiks1337143battiks
bawties124214313bawties
brails84621293bra__ils
brantails1146313brantails
brasils9410973bra_sils
brazils1867753bra_zils
camail10314833camail_
camels105217083cam_els
cammies134016483cammies
campily1638273campily
cantals93919573cantals
cartels94618123cartels
cattails1038553cattails
catties94023053catties
cattily123210853cattily
cavils114014393ca_vils
craftily1644783craftily
crampits1436273crampits
dactyls1333913dactyls
damsels10126713damsels
dauties83315763dauties
dawties113312703dawties
dentils84115583dentils
distils83015803distils
draftily1534413draftily
drails74716953dra__ils
dramatics1466923dramatics
emails84412343_emails
fails85631483fa__ils
family143311703fam_ily
fantails1139693fantails
fatties103018203fatties
fattily13379463fattily
fractals1346133fractals
frails93716473fra__ils
frazils1956123fra_zils
gambias125010733gambias
gambirs12359083gambirs
gambits12399723gambits
gambols1238593gambols
gamily123712183gam_ily
gamins94420053gam_ins
grails77518783gra__ils
gratins84119183gra_tins
gratis74819243gra_ti_s
graymails1542803graymails
hails85231643ha__ils
hamals114816833ham_als
hamauls12387823hamauls
hammals14409233hammals
hammily1736063hammily
hartals10313023hartals
hastily133010663hastily
iambics13425643iambics
instils7811453instils
jails125422943ja__ils
jammies183611293jammies
kails95525213ka__ils
kamiks11387913kam_iks
kamsins1346963kamsins
laities7320343laities
lambies113015113lambies
lamias85020613lam_ias
lattins74115483lattins
lentils73912973lentils
maftirs1236043maftirs
mails76037783__mails
maltols939403maltols
mamies104626243mam_ies
mammals10389273mammals
mammies104314763mammies
mantels94515043mantels
mantids103113623mantids
mantis83926033manti_s
martins93322063martins
mastics112614783mastics
matins84527783ma_tins
mattins93316143mattins
mils66045333__m_ils
moils76125753__moils
nails55730403na__ils
nasties73520493nasties
nastily103011033nastily
nattily103610323nattily
nautili746113nautili
nautilus844073nautilus
pails75833063pa__ils
panties94230933panties
pantile93918483pantile
pantiles103617153pantiles
partials101911963partials
parties93230863parties
pastels95215183pastels
pasties94529813pasties
pastil85018323pastil_
pastis84924323pasti_s
patins87528783pa_tins
patios85221783pa_tios
patties93425143patties
pistils93314303pistils
pontils9312213pontils
rabbies113416053rabbies
rabbins112811343rabbins
rabbis102613163rabbi_s
rabbits11299863rabbits
rabies85226023ra_bies
rachis114017653rachi_s
racily11715173ra_cily
radials83614643radials
radios74018673ra_dios
radius73914873ra_dius
raffias13237713raffias
rafters103715633rafters
rafting113815753rafting
rafts87820633raft__s
raggies93214733raggies
ragis66325603ra_gi_s
ragtags935373ragtags
ragtime1036163ragtime
ragtimes1135823ragtimes
ragtops1035453ragtops
raias54631123ra__ias
raids65827513ra__ids
rail46147763ra__il_
rainily10310433rainily
rains55140233ra__ins
rais45252623ra__i_s
raisins72715343raisins
raitas64417673rait_as
rakis95323443ra_ki_s
rallies73823343rallies
ramadas1039303ramadas
ramal74622243ram_al_
rambla103510933ram_bla
ramblas112710263ramblas
ramble104519973ram_ble
rambles113118313rambles
ramees84620893ram_ees
ramekins1466113ramekins
ramets83517393ram_ets
rami66034093ram_i__
ramie75027823ram_i_e
ramifies13310503ramifies
ramify14268753ram_ify
ramilie9310283ram_ilie
ramilies10311833ramilies
ramjets1635163ramjets
rammers113715043rammers
rammier112811023rammier
rammiest12299933rammiest
ramming123115063ramming
rammish1437563rammish
ramonas9311093ramonas
ramous8417113ram_ous
rampike1536603rampike
rampikes1635393rampikes
ramping123316873ramping
rampion11298583rampion
rampions12248023rampions
rampole1139693rampole
rampoles1238893rampoles
ramps96224633ram__ps
ramrods1036583ramrods
rams65950773ram___s
ramsons939563ramsons
ramus76418283ram__us
randies84225663randies
ranids75118703ra_nids
ranis55235833ra_ni_s
ranters73323643ranters
ranting84025413ranting
rants55935343rant__s
raphias123511083raphias
raphis114014323raphi_s
rapids94913893ra_pids
rappels11448803rappels
raptly11338913rapt_ly
raptors94213353raptors
rarities8316333rarities
rascals959663rascals
rasters74629023rasters
ratal55025113ra_tal_
ratans63819373ra_tans
ratel54224883ra_tel_
raters63936583ra_ters
rates55352013ra_t_es
ratify122610043ra_tify
ratine65131823ra_tine
ratines75328583ra_tines
rating74938703ra_ting
ratings84217413ra_tings
ratio55227583ra_ti_o
ration64226013ra_tion
rations74123433ra_tions
ratite65022423ra_tite
ratites74920683ra_tites
ratlin64116523ra_tlin
ratlins73615583ratlins
ratos55528763ra_t_os
rats46260373ra_t__s
rattail737803rattail_
rattans73411953rattans
rattens74213403rattens
ratters74422473ratters
rattier74015593rattier
rattiest83516113rattiest
ratting83822363ratting
rattish10510823rattish
rattle64717613ra_ttle
rattles73217303rattles
rattly94111543ra_ttly
rattons73815323rattons
ravels94717073ra_vels
ravins94622563ra_vins
rawins95617623ra_wins
realties8514853realties
reavails1134853reavails
reboils94111723reboils
recoils93814873recoils
redtails968003redtails
remail85017123remail_
remains94117913remains
remiss84216353rem_iss
remits85622943rem_its
renails74917263renails
rentals74017483rentals
reoils64516873r_eoils
reptile93914083reptile
reptiles103913073reptiles
resails74616743resails
retails74718973retails
reties65436193r_eties
retile65929673r_etile
retiles74426993r_etiles
ridgils9326573ridgils
roils54826793r__oils
rotis56327063r_oti_s
rotls55620163r_ot_ls
rummies113212793rummies
rustics9810733rustics
rustily103112993rustily
rutile65217683r_utile
rutiles74315843r_utiles
rutins63818393r_utins
ruttily10338613ruttily
sails55738103sa__ils
salties73725773salties
saltily10310543saltily
sambals115213483sambals
samiels939763samiels
samites93118713samites
santims9312603santims
santirs7312963santirs
santols73513323santols
satins64930483sa_tins
satis55633683sa_ti_s
tactics1149323tactics
tactile9310613tactile
tahsils1035053tahsils
tails55634193ta__ils
tamals84116633tam_als
tameins9311423tameins
tamis76728733tam_i_s
tammies113814683tammies
tartily103511573tartily
tastily103311643tastily
tatties74120343tatties
tattily10409993tattily
tils45739613___tils
tomtits937243tomtits
tractile10311073tractile
trails64622513tra__ils
tramells10327833tramells
tramels93812493tram_els
trammels12295413trammels
travails1146083travails
uracils939373ura_cils
vails85825933va__ils
vakils1337593va_kils
wagtails1244443wagtails
wails86631483wa__ils
yautias1046333yautias
zamias174212923zam_ias

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273357.17318684.9
3Display Results3353350.1232723.6
 (SQL Overall)1786913357.70223200.6
 
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.