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

112 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
gemmating157644(None) 
gelating103015732ge_lating
geminating1447752geminating
gemmation1445962gemmation
gemmations1545002gemmations
gemming13289142gemm__ing
gestating11229982gestating
remating112322412re_mating
summating1437942summating
aerating92821003ae_rating
animating12312503animating
beating104326873be__ating
bemeaning1436193bemeaning
bemisting1438073bemisting
bemoaning1435953bemoaning
berating113220763be_rating
bromating1439173bromating
cementing1438763cementing
combating16310163combating
commuting16288443commuting
cremating14312193cremating
debating123213733de_bating
decimating1648753decimating
defeating142311973defeating
deflating142610713deflating
delating103119603de_lating
demasting1338453demasting
demeaning1337243demeaning
dementing13311043dementing
demitting13239073demitting
demoting12311423de_moting
derating103222283de_rating
deviating14311083deviating
eating75134403_e__ating
elating83423083_e_lating
emanating1239003_emanating
embaying1635263_embaying
emitting112410353_emitting
emoting10313563_e_moting
empaling1338363_empaling
emulating1239873_emulating
equating18310113_equating
estating92614993_estating
fellating1339243fellating
gamming133112623gamm__ing
gammoning1545063gammoning
gating84826953g___ating
gearing92818843ge__aring
gelatin83514733ge_latin_
gelatine93213303ge_latine
gelatins93414093ge_latins
gemmate12418383gemmat__e
gemmated14336293gemmat_ed
gemmates13307673gemmat_es
generating12310383generating
germinating1546173germinating
getting93316563ge__tting
gimbaling15134443gimbaling
gimleting1343863gimleting
gloating102611463g_loating
gradating1237313gradating
grating93923183g__rating
grimacing1544033grimacing
grommeting1642913grommeting
grummeting1642453grummeting
gumming133810193gumm__ing
gyrating1337453g_yrating
heating114024323he__ating
helmeting1545503helmeting
hematin121516023he_matin_
hematine131614673he_matine
hematins131714683he_matins
hemming15269973hemm__ing
jemmying2332313jemm_ying
legating102313113le_gating
lemmatize2245563lemmatize
lemmatizing2554363lemmatizing
lemming12269393lemm__ing
mating94832913___mating
mediating13311203mediating
mismating141211823mismating
moating104218153__moating
negating102012833ne_gating
permeating1539923permeating
permuting1446553permuting
rebating112418343re_bating
recoating121317463recoating
recrating121318793recrating
redating102620173re_dating
reflating132514713reflating
regrating111316213regrating
reheating132314913reheating
reimaging1336503reimaging
relating92725443re_lating
remaking152613303re_making
remeeting12311433remeeting
remelting12311703remelting
reminting122315103reminting
remitting122412623remitting
repeating122618983repeating
replating122217403replating
reseating102421533reseating
reslating102516993reslating
restating102319413restating
rummaging1543363rummaging
seating84130683se__ating
sedating103014113se_dating
sensating1039253sensating
seriating10916403seriating
serrating10513203serrating
summiting1445793summiting
tempting1357343te_mpting

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411126.39023261.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911126.85926052.0
 
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.