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

405 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
rattans7341195(None) 
ratans63819371ra_tans
rattan63613601rattan_
rattens74213401rattens
rattons73815321rattons
atmans84413962_atmans
attains7310982_attains
attars64515312_attars
battens95313262battens
caftans12179442caftans
captans111612052captans
fattens105111712fattens
kaftans14185352kaftans
lattens75014672lattens
lattins74115482lattins
mattins93316142mattins
partans94418282partans
pattens95414922pattens
radians83013822radians
raglans82410132raglans
ragtags935372ragtags
raitas64417672raita_s
randans8313212randans
ratals64219582ra_tals
ratan53722662ra_tan_
ratany93411872ra_tany
ratatats846062ratatats
ratbags1035762ratbags
rations74123432rations
ratlins73615582ratlins
ratoons73815472ratoons
rattail737802rattail
rattails837132rattails
ratteens8256052ratteens
ratten64217382ratten_
ratters74422472ratters
ratting83822362ratting
rattles73217302rattles
ratton64116122ratton_
rattoons8327512rattoons
rattraps1044822rattraps
reattains946442reattains
tartans72615822tartans
actins86321103_actins
alans55636173_a_lans
altars64518153_altars
antas55432033_anta_s
artisans888523artisans
atamans9710433_atamans
ataps76414833_a_taps
atlas55821583_atla_s
atman75520143_atman_
atmas75721013_atma_s
attach11118393_attach
attack12148153_attack
attacks13126943_attacks
attain6311753_attain
attaint7313473_attaint
attaints846493_attaints
attar56516693_atta_r
attend7258973_attend
attends8257593_attends
attent62818323_attent
attics84413283_attics
attorns738443_attorns
attune637983_attune
attunes737823_attunes
avians93711563_avians
azans146516883_a_zans
banians9312033banians
bantams1149063bantams
banyans1237913banyans
batman105214063batman_
batons85519423ba_tons
batten85217123batten_
batters94626013batters
battiks1337143battiks
batting104422273batting
battings114010573battings
battles94517683battles
batts76727563batt__s
battues94610193battues
bettas84913923betta_s
brattles10199333brattles
buttals938503buttals
buttons9310333buttons
caftan111710123caftan_
caimans113811783caimans
callans94518473callans
cancans11311873cancans
cantals93919573cantals
cantons95221203cantons
capstans1257243capstans
captains121810573captains
captan101613343captan_
cartons94122473cartons
catenas9313113catenas
caterans10313223caterans
cations94524143cations
catjang1733923catjang
catjangs1843223catjangs
catkins133012563catkins
catlins93818843catlins
catnaps1197033catnaps
cattail939183cattail
cattails1038553cattails
cattalo938423cattalo
cattalos1037933cattalos
catties94023053catties
catting103922643catting
caymans14349513caymans
cotans81317923_cotans
cottars94412243cottars
cottas84615573cotta_s
cottons9312193cottons
cratons94316033cra_tons
daltons8310403daltons
damans94715983da_mans
dattos74311903datt_os
dittany1135653dittany
dratting10389663dratting
fastens105511753fastens
fatten94314903fatten_
fatties103018203fatties
fatting113818703fatting
fatwas1249053fatwa_s
flattens11357483flattens
fractals1346133fractals
gateaus866333gateaus
gratins84119183gra_tins
habitans1346623habitans
haptens124511343haptens
harmattans1572603harmattans
hartals10313023hartals
hastens106214813hastens
hatband1346823hatband
hatbands1446293hatbands
hatpins123410643hatpins
hatters104221523hatters
hatting113920233hatting
hazans183411653ha_zans
hazzans18215783hazzans
hetmans12187593hetmans
japans1539823ja_pans
jawans1657843ja_wans
jettons1437273jettons
kaftan13185823kaftan_
kalians11310183kalians
kanbans1337723kanbans
kantars11310033kantars
katas95922093ka_ta_s
kations114013663kations
kittens11347583kittens
lactams1136953lactams
lagans75717783la_gans
lallans74113533lallans
lantana739603lantana
lantanas838263lantanas
lateens74210553lateens
latens64620213la_tens
latinas74416463latinas
latten65018203latten_
lattes65324203latt_es
lattin64316223lattin_
lauans65113533la_uans
lyttas985073lytta_s
magians10310753magians
mannans93611523mannans
mantas85725363manta_s
martens93714953martens
martians103111613martians
martins93322063martins
matins84527783ma_tins
matrass939403matrass
matrons93517633matrons
matsahs1236563matsahs
matters94421753matters
mattes85624533matt_es
mattin84416633mattin_
matting103620143matting
mattings11369673mattings
mattrass1045863mattrass
matts76829183matt__s
matzahs2134483matzahs
matzas1749703matza_s
mittens9349883mittens
muttons949283muttons
naans55815253na__ans
natant6318733na_tant
nations74720563nations
natrons73215663natrons
natters73718063natters
octans81411143_octans
orations81515803orations
ottars64112223_ottars
outmans92413283outmans
paeans85118263pa_eans
paesans93312693paesans
pagans95717923pa_gans
paisans93614753paisans
parians93519733parians
partan83820563partan_
partons94620513partons
pastas85422873pasta_s
patens84820863pa_tens
patinas96318523patinas
patins87528783pa_tins
patrons93818103patrons
patten84418193patten_
patterns10439943patterns
patters94825193patters
patties93425143patties
patting103722343patting
pattypans1641753pattypans
pavans115715593pa_vans
pitmans11188743pitmans
pittas86014523pitta_s
platans93413123platans
prattles10189403prattles
proteans102811543proteans
quartans1736283quartans
rabatos93010903rabatos
rabats83116223ra_bats
rabbins112811343rabbins
racons84319343ra_cons
racoons93912433racoons
radars71314673ra_dars
radials83614643radials
radian74117273radian_
radiant82817133radiant
radiants9259443radiants
radons74118533ra_dons
rafters103715633rafters
rafting113815753rafting
rafts87820633raft__s
ragas65326063ra_ga_s
ragbags1135113ragbags
raglan73711503raglan_
ragman94013713ragman_
ragtag836643ragta_g
ragtops1035453ragtops
raias54631123ra_ia_s
rains55140233ra__ins
raisins72715343raisins
raita54623073raita__
rajahs16497663ra_jahs
rajas127317723ra_ja_s
rambutans1343103rambutans
ramonas9311093ramonas
rampant11312173rampant
ramsons939563ramsons
ramtils938413ramtils
randan7315253randan_
ranters73323643ranters
ranting84025413ranting
rants55935343rant__s
raptors94213353raptors
rascals959663rascals
rasters74629023rasters
ratal55025113ra_ta_l
ratanies8312923ra_tanies
rataplans1143823rataplans
ratatat7412263ratatat
ratbag956563ratba_g
ratches123620463ratches
ratels64518213ra_tels
raters63936583ra_ters
rates55352013ra_t_es
ratfink1434943ratfink
ratfinks1542853ratfinks
ratine65131823ra_tine
ratines75328583ratines
rating74938703ra_ting
ratings84217413ratings
ration64226013ration_
ratios64922673ra_tios
ratites74920683ratites
ratlin64116523ratlin_
ratline74517803ratline
ratlines83815293ratlines
ratoon64417373ratoon_
ratos55528763ra_t_os
rats46260373ra_t__s
ratsbane10184343ratsbane
ratsbanes1194163ratsbanes
ratted74923343ratt_ed
ratteen7329113ratteen
rattened9218623rattened
rattener8238533rattener
ratteners9237263ratteners
ratter64326313ratt_er
rattier74015593rattier
rattiest83516113rattiest
rattish10510823rattish
rattle64717613ratt_le
rattled84012953rattled
rattler74012743rattler
rattlers83510293rattlers
rattling92510873rattling
rattlings10235513rattlings
rattly94111543ratt_ly
rattoon7359243rattoon
rattrap945263rattrap
ratty84819593ratt__y
ravens93916883ra_vens
ravins94622563ra_vins
rawins95617623ra_wins
rayahs12579193ra_yahs
rayas85922053ra_ya_s
rayons94113343ra_yons
reactant10311433reactant
reactants1146623reactants
reatas64021013reata_s
reattach1343743reattach
reattack1444123reattack
reattacks1543753reattacks
reattain846733reattain
redans75421023r_edans
regattas944473regatta_s
reloans7313133reloans
remans84823003r_emans
rentals74017473rentals
replans92814943replans
reptant92817073reptant
retags73414303r_etags
retains74522253retains
reteams9339563reteams
retears72814923retears
retinas74819353retinas
retotals838463retotals
retrains8314533retrains
retting83425883retting
returns79712593returns
rhatany1353693rhatany
rhytons13295883rhytons
riatas63915093riata_s
ritters74020623ritters
rituals738353rituals
roans54926443r__oans
romans84620243r_omans
rotas54827723r_ota_s
rotates72819773rotates
rotten64115433rotten_
rotters74421393rotters
rottes64524833rott_es
rotting82919683rotting
rowans95715343r_owans
rutins63818393r_utins
rutting82718043rutting
ryokans1443293ryokans
saltant7316773saltant
saltpans1034813saltpans
sampans112411003sampans
sarans64224433sa_rans
satang75711563sa_tang
satangs8479713sa_tangs
satays94411683sa_tays
sateens73710753sateens
satins64930483sa_tins
satraps95011643satraps
seitans73312303seitans
sextans14349273sextans
shaitans1136413shaitans
statant7313123statant
statins73719773statins
sultans72411833sultans
suntans72111733suntans
suttas63813793sutta_s
taipans9269553taipans
tampans113310983tampans
tans46154823___tans
tarpans92513533tarpans
tartan64217513tartan_
tartana73010193tartana
tartanas8258893tartanas
tartars73313403tartars
tarzans16329923tarzans
tatars64619793ta_tars
tatters74520483tatters
tatties74120343tatties
tatting84019523tatting
tattings9408823tattings
tattles73616283tattles
tattoos738643tattoos
tautens7317843tautens
titans63414913_titans
titians72710453titians
trans54933043__trans
trapans92812463tra_pans
triptans1047363triptans
urethans1145243urethans
vatting113614853vatting
wangans1149503wangans
wantons103713013wantons
wataps11248683wa_taps
wattage1186983wattage
wattages12106783wattages
wattape12135383wattape
wattapes1395253wattapes
wattles103814073wattles
watts86923093watt__s
witans93412933_witans
xanthans1845693xanthans
yatagans1244083yatagans
yatters103914623yatters

Search took 7 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.420425454.8
2DLD Change Limit1340274056.05022153.2
3Display Results4054050.1562596.2
 (SQL Overall)1786914056.62626968.2
 
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.