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

103 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
ramekins146611(None) 
ramekin13126491ramekin_
lambkins1664982lambkins
ramequins2042722ramequins
ravelins113011602ravelins
tameins9311422tame_ins
acetins9313173_acetins
alevins102110583_alevins
alexins141910663_alexins
amens75624843_ame__ns
amidins103713103_amidins
amins75534323_am__ins
baudekins1642433baudekins
bromelins1346463bromelins
bumkins15318013bum_kins
bumpkins1843703bumpkins
calkins133814873ca_lkins
camelias12510313camelias
camelids1356943camelids
cameoing1379063cameoing
canakins142010463canakins
canikins14219163canikins
capelins12311133capelins
capeskins1744073capeskins
caseins93115053case_ins
catkins133012563ca_tkins
dramedies1345123dramedies
emetins9812653_emetins
fadeins1168503fade_ins
gamelans11115853gamelans
gamins94420053gam__ins
gaskins123510773ga_skins
haemins122811403ha_emins
javelins18277733javelins
kamsins1346963kam_sins
ladykins1643603ladykins
lambkin1545243lambkin_
lambskins1753243lambskins
laminins1039133laminins
limekilns1541533limekilns
limpkins1644233limpkins
lomeins969483lome_ins
malkins133311803ma_lkins
manakins14209763manakins
manikins14189723manikins
nankins1159053na_nkins
napkins1336673na_pkins
pekins121812233__pekins
pumpkins1843853pumpkins
rabbins112811343ra_bbins
racking144323663ra_cking
rains55140233ra___ins
raisins72715343ra_isins
raking114728423ra__king
rakis95323443ra__ki_s
rambling131810773rambling
ramees84620893rame__es
ramen75625193rame__n_
ramequin1942823ramequin_
ramets83517393rame__ts
ramies84630463ram__ies
ramifies13310503ramifies
ramilies10311833ramilies
ramming123115063ram_ming
rampikes1635393rampikes
ramping123316873ram_ping
rampions12248023rampions
ramsons939563ram_sons
ramtils938413ram_tils
ranking124320883ra_nking
rankings13389173ra_nkings
rarebits1045233rarebits
rarefies1138993rarefies
ratlins73615583ra_tlins
ravelin102211023ravelin_
raveling123414373raveling
ravelings13377383ravelings
ravening122611293ravening
ravenings13235183ravenings
ravens93916883rave__ns
ravins94622563ra__vins
rawins95617623ra__wins
razeeing1834363razeeing
rebegins1136003rebegins
redskins1385873redskins
reeking123318643r_eeking
reins56234563r__e_ins
remains94117913rem_ains
remaking152613303remaking
remedies11310553remedies
renins64526453r__enins
repins84924313r__epins
resins64528773r__esins
rewins95020823r__ewins
rumakis1335533rumaki_s
rumens83611813rume__ns
samekhs16303923samek_hs
sameks12409323samek__s
takins105117403ta__kins
tamarins10310843tamarins
tamein8313093tame_in_
trameling1249053trameling
yamens114010823yame__ns

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.420425454.8
2DLD Change Limit1461621037.09320606.5
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.55923639.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.