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

156 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
gemmates1330767(None) 
gemmate12418381gemmate_
gemmated14336291gemmated
agemates111110022age_mates
bedmates1349182bedmates
gelates83219582ge_lates
geminates12310032geminates
gemmae11507792gemma_e_
gemmules13183212gemmules
gemotes103712142ge_motes
gestates93213732gestates
gummites1346172gummites
remates93827112re_mates
summates122610492summates
teammates1345672teammates
aerates74627493ae_rates
agemate101210583age_mate_
animates101316423animates
bedmate1239433bedmate_
berates94126873be_rates
bromates12413143bromates
cellmates1347513cellmates
cerates95428253ce_rates
climates12311973climates
comates114123643_comates
commutes143011893commutes
cremates124216003cremates
crewmates16375803crewmates
dealates92716683dealates
debates103718533de_bates
decimates14410693decimates
deflates123013943deflates
delates83526283de_lates
demotes104717673de_motes
derates84028893de_rates
deviates12312733deviates
elates65032363_e_lates
eluates72014683_eluates
emanates10311333_emanates
emeutes938013_emeutes
emirates101214853_emirates
emmets10349153_emmet_s
emotes84620283_e_motes
empales112411433_empales
emulates10312573_emulates
enates64026433_e_nates
equates162012323_equates
ergates8314493_ergates
estates74520183_estates
fellates11312753fellates
females12310663fe_males
femmes135410213femm__es
fermatas13246223fermatas
fermate122813003fermate_
ferrates113013423ferrates
formates132814293formates
gallates92815523gallates
gambades1435863gambades
gametes10312253g_ametes
gammas115714693gamma__s
gates65939513g___ates
gelate73421253ge_late_
gelated93615633ge_lated
gelatis83313513ge_latis
gelatos83111513ge_latos
geminate11411803geminate_
geminated1338543geminated
gemma106311773gemma___
gemmating1576443gemmating
gemmation1445963gemmation
gemmations1545003gemmations
gemmed12329573gemm__ed
gemmier12337383gemm_ier
gemmiest13227623gemm_iest
gemminess1464633gemminess
gemmule12173233gemmule_
gemote94613023ge_mote_
gemots93712153ge_mot_s
generates10312713generates
genettes938303genettes
gentes75324163ge__ntes
geometer1138423geometer
geometers1238193geometers
geotaxes1644743geotaxes
germane1049663germane_
germans1079473germa_ns
germinates1347763germinates
gestate83614073gestate_
gestated102910573gestated
gestes75721393ge__stes
gimmals12225823gimma_ls
gimmes113010903gimm__es
gimmies123010113gimm_ies
gradates10510783gradates
grates75429893g__rates
gremmies1355993gremm_ies
grimaces1355383grimaces
gummas114810513gumma__s
gummata1244613gummat_a
gummatous1442733gummatous
gummite1236133gummite_
gummoses1344743gummoses
gyrates113610263g_yrates
hamates122917683_hamates
helpmates1645513helpmates
humates122813193_humates
imamates1237663imamates
inmates92715783_inmates
jemmies18318333jemm_ies
legates82917683le_gates
lemmas10349163lemma__s
lemmata1144673lemmat_a
lemmatizes2345013lemmatizes
mammate104411273mammate_
mammatus1144233mammatus
mates75251363___mates
mediates112814063mediates
messmates1346233messmates
metates92720013me_tates
mismates121114563mismates
negates83215843ne_gates
neonates8310063neonates
pectates122213953pectates
penates93321603pe_nates
permeates13311773permeates
permutes1238713permutes
primates121515933primates
rebates95123183re_bates
recrates102420373recrates
redates83423873re_dates
reflates113115663reflates
regrates92618403regrates
reimages1138373reimages
relates73731433re_lates
remakes134116173re_makes
remate84428683re_mate_
remated103522473re_mated
remotes94521613re_motes
replates102919273replates
reslates83619503reslates
restates83423433restates
roommates1344843roommates
rummages1344933rummages
seatmates1157823seatmates
sedates83418043se_dates
senates73322613se_nates
sensates8511143sensates
seriates82620673seriates
serrates82617023serrates
stomates10313343stomates
summate113611663summate_
summated13298833summated
teammate1245613teammate_
templates1348273templates
termites10313693termites
testates83615453testates

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 Limit1461621566.72021750.3
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.20324807.9
 
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.