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

127 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
cumarins123864(None) 
coumarins1347021coumarins
cumarin1139261cumarin_
coumarin1247322coumarin_
cumins103314932cum__ins
cummins1358962cum_mins
curarine10610712curarine
curarines11710552curarines
curaris94114772curari_s
tamarins10310842tamarins
bumkins15318013bum_kins
bumpkins1843703bumpkins
burins84221893bu__rins
butyrins1345423butyrins
cabins104418923c__abins
cains75334303c__a_ins
cairns85313303c__airns
camails11311753cama_ils
cambrics1645253cambrics
canakins142010463canakins
canaries10318943canaries
carabins12312363carabins
caries85147623c__aries
carina84325323c__arina
carinas93622403c__arinas
caring95137993c__aring
carlins93921913c__arlins
carns75937563c__ar_ns
ceratins102818733ceratins
cesarians1146363cesarians
chagrins1437073chagrins
chains114819703c_ha_ins
charing133721323c_haring
chlorins132612883chlorins
cinerins10414103cinerins
citrins92614363c_itrins
claries93422203c_laries
clarions10310493c_larions
clearing113014883clearing
clearings12286063clearings
cocains111313923coca_ins
comaking1739993comaking
comatiks16148043comatiks
comparing162410583comparing
complins14313113complins
coumaric1446173coumari_c
coumarone1343513coumarone
coumarones1443863coumarones
coumarous1385783coumarous
covaries13413253covaries
creatins103617513creatins
cremains1238693crema_ins
culprits1245583culprits
culverins1445373culverins
cumbering16108203cumbering
cumbias13338963cum_bias
cumbrous1446173cumbrous
cumin94616973cum__in_
cummin1288783cum_min_
curacies12311763curacies
curaras93911953curar_as
curares94916853curar_es
curari84414403curari__
curarize1988853curarize
curarizes2078173curarizes
curating11314293curating
curies84934023cu__ries
curing94824783cu__ring
curios83218333cu__rios
curns74924283cu__r_ns
currans9310613cu_rrans
curries93723163cu_rries
curring103616843cu_rring
curtains10259703curtains
cutins83919983cu__tins
cyanins122910013c_yanins
cycasins1545283cycasins
cymars13599153cymar__s
cymlins1436693cym_lins
czarina1845953c_zarina
czarinas1935293c_zarinas
dicoumarins1652243dicoumarins
domains10510873doma_ins
fumaric1446303fumari_c
fusains1038363fusa_ins
guanins8810013gu_anins
hematins131714683hematins
heparins13310123heparins
humans112312433huma__ns
humoring1456853humoring
lunarians945513lunarians
mains75635113__ma_ins
margins103815193__margins
marina84623413__marina
marinas93519383__marinas
marine84230403__marine
marines93928013__marines
marlins93420473__marlins
martins93322063__martins
matins84527783__matins
mavins115119183__mavins
mirins83918903__mirins
murrains1036853murrains
numerics1266283numerics
ouraris73512933ourari_s
outgrins979823outgrins
pumpkins1843853pumpkins
purins83722653pu__rins
remains94117913rema_ins
rumakis1335533rumaki_s
rumoring1136983rumoring
sarins63932623__sarins
savarins1139893savarins
stearins8312143stearins
suberins10315093suberins
submarine1347843submarine
submarines1446913submarines
sudaries9312753sudaries
sugaring1039053sugaring
summaries13118183summaries
tamarin9311913tamarin_
tamarind1147023tamarind
tamarinds1244163tamarinds
tamaris9413593tamari_s
tumbrils12255373tumbrils
umamis1038273_umami_s
uraris63817273_urari_s

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.410435831.7
2DLD Change Limit1461621277.34319904.9
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.79922912.0
 
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.