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 “gamelans” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
gamelans1111584(None) 
gamelan10106641gamelan_
capelans1238012capelans
akelas10311193_akela_s
alans55636173_a__lans
ameban1039093_ameban_
amebas10311453_ameba_s
amens75624843_ame__ns
bemeans1148733beme_ans
callans94518473ca_llans
camelias12510303camelias
camelids1356943camelids
camels105217083camel__s
cameras11313363camera_s
capelan1139003capelan_
capelins12311133capelins
caterans10313223caterans
damans94715983dam__ans
demeans1039713deme_ans
elans55527753___elans
fameless13259203fameless
favelas1337023favela_s
gabelles11278933gabelles
galahs105512673ga__lahs
galas65731643ga__la_s
galeas74618513gale_a_s
galenas83310343galena_s
gallant83517113ga_llant
gallants93310373ga_llants
galleass935053galleass
galleins9258693galleins
galleons9258443galleons
gallons83015953ga_llons
gamas85431363gam__a_s
gamays126310913gam__ays
gambas115817513gam_ba_s
gambesons1442343gambesons
gambias125010733gambia_s
gamblers13369733gamblers
gambles124016203gambl_es
gambling14218963gambling
gamelike1538033gamelike
gamely124711913gamel__y
gameness112810693gameness
gamers94420833game__rs
games86238553game___s
gamesman1344513gamesman_
gametal1037603gameta_l
gametes10312253game_tes
gamins94420043gam__ins
gammas115714693gam_ma_s
gammons1237973gam_mons
gangland1145193gangland
ganglands1244453ganglands
garland948703ga_rland
garlands1038323ga_rlands
gateaus866333gate_aus
gateless9279953gateless
gateman1057473gateman_
gateways1544613gateways
gaveling133410163gaveling
gavels105911093gavel__s
gazelles18266563gazelles
gelant72821673g__elant
gelants82611443g__elants
gimels938893gimel__s
glans65125833g___lans
gleans75014743g_le_ans
gomerals1147443gomerals
gremlins1136043gremlins
homeland1446233homeland
homelands1545443homelands
javelins18277733javelins
kamalas13339123kamala_s
lallans74113533la_llans
lamellas1098163lamellas
means75831233__me_ans
melons84117713__melons
nameless10248373nameless
nametags1143093nametags
paeans85118263pa_e_ans
paesans93312693pa_esans
pampeans1444703pampeans
parmesans1344103parmesans
raglans82410133ra_glans
ramblas112710263rambla_s
ramekins1466113ramekins
ravelins113011603ravelins
sampans112411003sam_pans
tameins9311413tame_ins
tameless10259903tameless
tampans113310983tam_pans
yamens114010823yame__ns

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 Filter1786911461620.406440125.6
2DLD Change Limit146162936.33023090.4
3Display Results93930.0462021.7
 (SQL Overall)178691936.78226347.8
 
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.