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

331 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
raglans8241013(None) 
raglan73711501raglan_
alans55636172_a_lans
callans94518472callans
glans65125832__glans
lagans75717782lag_ans
lallans74113532lallans
magians10310752magians
pagans95717922pag_ans
radians83013822radians
ragas65326062rag_a_s
ragbags1135112ragbags
ragman94013712ragman_
ragtags935372ragtags
randans8313212randans
ratans63819372ra_tans
ratlins73615582ratlins
rattans73411952rattans
replans92814942replans
ablins8316193_ablins
afghans1443573afghans
agars66120643_ag_ars
agas55938843_ag_a_s
aghas97014873_agha_s
aglare7312423_aglare
aglets73915683_aglets
agmas85919873_agma_s
agons66423783_ag_ons
alan46844083_a_lan_
aland65526413_a_land
alands75418373_a_lands
alane56135613_a_lane
alang66023513_a_lang
alant55742293_a_lant
alants67722023_a_lants
alas46358123_a_la_s
algas65624933_alga_s
algins74816433_algins
allays94313743_allays
anlas55626933_anla_s
argalas84011093argalas
argalis84214193argalis
argals75517713arg_als
argles75218483argl_es
argling92812733argling
argons75018203arg_ons
aslant6317753_aslant
ataghans1244263ataghans
atlas55821583_atla_s
atmans84413963_atmans
avians93711563_avians
azans146516883_a_zans
azlons154110423_azlons
badland1147653badland
badlands1236673badlands
bagass938933bag_ass
bagman114613813bagman_
balas76937213ba_la_s
ballads104212913ballads
ballons93916963ballons
banians9312033banians
banyans1237913banyans
beglads11127263beglads
bogans95714813bog_ans
brogans1049663brog_ans
caftans12179443caftans
caimans113811783caimans
callan83619603callan_
callant94121223callant
callants104112143callants
callas84526753calla_s
cancans11311873cancans
capelans1238013capelans
caplins113515993caplins
captans111612053captans
carlins93921913carlins
catlins93818843catlins
caymans14349513caymans
clans75031013__clans
daggas937973dagga_s
damans94715983da_mans
dragline1036843dragline
draglines1145993draglines
dragomans1343323dragomans
dragons938383drag_ons
dragoons1045013dragoons
eagles73819163eagl_es
eaglets84111663eaglets
eagling91113603eagling
earlaps936393earlaps
elans55527753__elans
fagins10513863fag_ins
fallals103310193fallals
flans85327973__flans
fragrant1247113fragrant
franglais1343283franglais
gagman103811243gagman_
galahs105512673ga_lahs
galas65731643ga_la_s
gallant83517113gallant
gallants93310373gallants
gallons83015953gallons
gamelans11115843gamelans
gangland1145193gangland
ganglands1244453ganglands
garland948703garland
garlands1038323garlands
glads75620613__glads
glams85822933__glams
gland75217713__gland
glands85314403__glands
glass65518133__glass
gleans75014743__gleans
glens66519853__glens
grans64832543__grans
graplins1148263graplins
gravlaks1642423gravlaks
graylags1372983graylags
guans64419443__guans
hagdons1258523hagdons
halals95018313ha_lals
hallahs133912463hallahs
halons95720713ha_lons
hazans183411653ha_zans
hazzans18215783hazzans
hogans105914313hog_ans
jagless1537103jagless
jagras1438463jagra_s
jaguars1535233jaguars
jalaps15299183ja_laps
japans1539823ja_pans
jawans1657843ja_wans
kaftans14185353kaftans
kalams12310603ka_lams
kalians11310183kalians
kanbans1337723kanbans
kaolins1139363kaolins
lagan66520343lag_an_
lagoons839253lagoons
lagunas8156823lagunas
lallan63414173lallan_
lalland83810173lalland
lallands9338563lallands
lauans65113533la_uans
ligans76817733lig_ans
lignans8398853lignans
logans76319063log_ans
magian9312833magian_
maglevs1334693maglevs
magmas115512503magma_s
malars85020683ma_lars
mannans93611523mannans
marlins93420473marlins
naans55815253na__ans
nagana748943nag_ana
naganas847983nag_anas
nalas55528363na_la_s
organs7912913org_ans
origans839973orig_ans
ortolans846553ortolans
paeans85118263pa_eans
paesans93312693paesans
pagan86121163pag_an_
pageant10312783pageant
pageants1136693pageants
paisans93614753paisans
palais8420423pa_lais
parians93519733parians
parlays123910453parlays
partans94418283partans
paulins9312613paulins
pavans115715593pa_vans
plans75731273__plans
preplans1249613preplans
prolans9314273prolans
rabats83116223ra_bats
rabbins112811343rabbins
racons84319343ra_cons
racoons93912433racoons
radars71314673ra_dars
radials83614633radials
radian74117273radian_
radiant82817133radiant
radiants9259443radiants
radons74118533ra_dons
radulas839583radula_s
raga55930813rag_a__
ragbag1045463ragba_g
ragees74618663rag_ees
rages64539443rag__es
raggees93710913raggees
raggies93214733raggies
ragging103516683ragging
raggles93813283raggles
raggs75216473rag__gs
raging85126433rag_ing
ragis66325603rag__is
ragmen93712183ragmen_
ragouts838543ragouts
rags55448373rag___s
ragtag836643ragta_g
ragtops1035453ragtops
raias54631123ra_ia_s
railbus934413railbus
railcars1045313railcars
railers74420663railers
railing83325643railing
railings93412153railings
rails55937403rail__s
railways1444603railways
rains55140233ra__ins
raisins72715343raisins
raitas64417673raita_s
rajahs16497663ra_jahs
rajas127317723ra_ja_s
rales54947493ra_l_es
rallies73823343rallies
ralline73518413ralline
rallyes10348553rallyes
ralphs1135373ra_lphs
ramblas112710263rambla_s
ramonas9311093ramonas
rampant11312173rampant
ramsons939563ramsons
randan7315253randan_
rangeland1143383rangeland
rangelands1242793rangelands
ranulas7311773ranula_s
rascals959663rascals
ratals64219583ra_tals
ratan53722663ra_tan_
ratany93411873ra_tany
rataplans1143823rataplans
ratbags1035763ratbags
rations74123433rations
ratlin64116523ratlin_
ratline74517803ratline
ratlines83815293ratlines
ratoons73815473ratoons
rattan63613603rattan_
rattens74213403rattens
rattons73815323rattons
ravelins113011603ravelins
ravens93916883ra_vens
ravins94622563ra_vins
rawins95617623ra_wins
rayahs12579193ra_yahs
rayas85922053ra_ya_s
raygrass1242883raygrass
rayless10239003rayless
rayons94113343ra_yons
reagins84215643reag_ins
realgars934533realgars
reclads1049993reclads
recleans1037513recleans
redans75421023r_edans
reflags1156953reflags
regains84316583regains
regales83520793regales
regears83012463regears
reggaes948883reggaes
reginas85614063reginas
regions83613473regions
reglaze1747223reglaze
reglazes1846793reglazes
reglets83512983reglets
regloss8218023regloss
reglows11288843reglows
reglues838713reglues
regnant8312843regnant
regrant8317323regrant
regrants9310013regrants
regulars936253regulars
reland75920433r_eland
relands85214883r_elands
relays94316753r_elays
reloans7313133reloans
remans84823003r_emans
replan83215823replan_
replant93318533replant
replants102811243replants
replays12399763replays
rimland1035663rimland
rimlands1145243rimlands
roans54926443r__oans
romans84620243r_omans
rowans95715343r_owans
rugolas836373rugola_s
ryokans1443293ryokans
sagas66025883sag_a_s
saggars93610683saggars
salads75316963sa_lads
salals65120083sa_lals
salons63823693sa_lons
sampans112411003sampans
sarans64224433sa_rans
solans64122493_solans
tablas83716163tabla_s
taggant9310223taggant
taggants1044933taggants
tagline82412453tagline
taglines92210833taglines
tagrags936123tagrags
tailfans1144553tailfans
taipans9269553taipans
talars66021683ta_lars
talas55935893ta_la_s
talons64019433ta_lons
tampans113310983tampans
tarpans92513533tarpans
tartans72615823tartans
tarzans16329923tarzans
tiglons837343tiglons
tolans64319273_tolans
tragopans1244103tragopans
trapans92812463tra_pans
uhlans937573_uhlans
ulans54921303__ulans
vaginas11298813vaginas
vagrant11410663vagrant
vagrants1246143vagrants
vegans103910853veg_ans
waggons1235503waggons
wagons103911213wag_ons
wallahs13409473wallahs
wallas95719393walla_s
wangans1149503wangans
waylays1634673waylays
wigans104511703wig_ans
xylans1635883_xylans
yulans958673_yulans

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.1561145455.1
2DLD Change Limit1340273316.84319586.0
3Display Results3313310.1262627.0
 (SQL Overall)1786913317.12525079.4
 
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.