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

111 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
ramekin1312649(None) 
ramekins1466111ramekins
lambkin1545242lambkin
ramen75625192rame__n
ramequin1942812ramequin
ravelin102211022ravelin
tamein8313092tame_in
acetin8314693_acetin
akin86328033_a__kin
alevin92511513_alevin
alexin132311483_alexin
amain74922913_am_ain
ameban1039093_ameban
amebic1239113_amebic
amen66733153_ame__n
amidin94015673_amidin
amin66042253_am__in
baudekin1542703baudekin
bromelin1246343bromelin
bumkin14308083bum_kin
bumpkin1743613bumpkin
calkin123515493ca_lkin
camelia11510433camelia
camelid1249413camelid
cameoing1379063cameoing
canakin131810833canakin
canikin13189753canikin
capelin11510973capelin
capeskin1644403capeskin
casein83216453case_in
catkin123512383ca_tkin
emetin8613463_emetin
fadein1068843fade_in
gamelan10106643gamelan
gametic1239993gametic
gamin84423003gam__in
gaskin113610583ga_skin
haemin113412663ha_emin
javelin17306983javelin
kamsin1238323kam_sin
ladykin1543963ladykin
lambkins1664983lambkins
lambskin1653443lambskin
laminin939973laminin
limekiln1441863limekiln
limpkin1534223limpkin
lomein8410203lome_in
malkin122913153ma_lkin
manakin131810643manakin
manikin132110243manikin
nankin1039673na_nkin
napkin1236903na_pkin
pekin111514423__pekin
pumpkin1743523pumpkin
rabbin103112303ra_bbin
racemic1336983racemic
racking144323663ra_cking
ragmen93712183ragme__n
rain46251733ra___in
raisin62716923ra_isin
raki87127833ra__ki_
raking114728423ra__king
rakis95323443ra__kis
rambling131810773rambling
ramee74633853rame__e
ramees84620893rame_es
ramenta9311183ramenta
ramequins2042723ramequins
ramet75743143rame__t
ramets83517393rame_ts
rami66034093ram__i_
ramie75027823ram__ie
ramilie9310283ramilie
ramming123115063ram_ming
rampike1536603rampike
ramping123316873ram_ping
rampion11298583rampion
ramson8310463ram_son
ramtil8311023ram_til
ranking124320883ra_nking
rarebit948423rarebit
ratlin64116523ra_tlin
raveling123414373raveling
ravelins113011603ravelins
raven84723443rave__n
ravening122611293ravening
ravin85624653ra__vin
rawin85521473ra__win
razeeing1834363razeeing
rebegin1036213rebegin
redskin1286023redskin
reeking123318643r_eeking
rein46040893r__e_in
remain85919863rem_ain
remaking152613303remaking
renin54830033r__enin
repin75324703r__epin
resin54131053r__esin
rewin85623963r__ewin
rumaki1235133rumaki_
rumakis1335533rumakis
rumen74419503rume__n
samek114915273samek__
samekh15355133samek_h
samekhs16303923samekhs
sameks12409323samek_s
takin94921303ta__kin
tamarin9311913tamarin
tameins9311413tame_ins
trameling1249053trameling
yamen104115183yame__n

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.406440125.6
2DLD Change Limit1340271116.17021722.4
3Display Results1111110.0502220.0
 (SQL Overall)1786911116.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.