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

55 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
gemmules1318321(None) 
gemmule12173231gemmule_
gemmates13307672gemmates
ampules1189433_ampules
bemuses1139293be_muses
besmiles1237393besmiles
cellules1036813cellules
communes143411243communes
commutes143011893commutes
emeutes938013_emeutes
empales112411433_empales
females12310663fe_males
femmes135410213femm__es
ferrules1136163ferrules
ferules103112723fe_rules
gambles124016203g_ambles
gemmae11507793gemm_ae_
gemmate12418383gemmate_
gemmated14336293gemmated
gemmed12329573gemm__ed
gemmier12337383gemm_ier
gemmiest13227633gemm_iest
gemmily1534603gemmil_y
gemminess1464643gemminess
gemotes103712143ge_motes
geniuses935933geniuses
gentiles93713523gentiles
gentles83714343ge_ntles
genuses83510883ge_nuses
gestures9310013gestures
gimmals12225823gimmal_s
gimmes113010903gimm__es
gimmies123010113gimm_ies
globules1135413globules
granules939943granules
gremmies1355993gremm_ies
grumbles13288873grumbles
guayules1243223guayules
gules64831043g___ules
gummites1346173gummites
gummoses1344743gummoses
hercules1337633hercules
hummuses1544453hummuses
immunes1136083_immunes
immures1136713_immures
jemmies18318333jemm_ies
lemures938793le_mures
mules75034293___mules
nervules1145013nervules
permutes1238713permutes
plumules1234663plumules
temples112610893te_mples
veinules1135913veinules
venules104011483ve_nules
wammuses1543493wammuses

Search took 10 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.483369960.7
2DLD Change Limit146162558.65616885.6
3Display Results55550.0331666.7
 (SQL Overall)178691559.17219482.2
 
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.