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

75 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
gammoning154506(None) 
gamboling1556132gamboling
gamming133112622gamm__ing
hamboning1745892hamboning
summoning14115692summoning
tamponing1445992tamponing
ammonia1148693_ammoni_a
ammoniac1455743_ammoniac
ammonias1247953_ammonias
ammonic1349163_ammoni_c
ammonify1843353_ammonify
ammonite1249143_ammonite
ammonium1145883_ammonium
aproning11311793_aproning
armoring1149123_armoring
atoning83514873_a_toning
bamming144611813bamm__ing
cameoing1379063cameo_ing
cannoning1237323cannoning
cantoning12310883cantoning
canyoning1536873canyoning
cartoning12311113cartoning
commoving1944983commoving
communing16207863communing
damming133812743damm__ing
damning114211633da_m_ning
dampening1535463dampening
gadrooning1343543gadrooning
gaining94015663ga__ining
galloping1356253galloping
galoping1258023ga_loping
gambling14218963ga_mbling
gambolling1643443gambolling
gaming104622043ga_m__ing
gammon1138903gammo__n_
gammoned1444993gammon_ed
gammoner1345153gammon_er
gammoners1444563gammoners
gammons1237973gammo__ns
gaoling93314653ga__oling
gardening1236513gardening
garmenting1445483garmenting
garoting10510703ga_roting
garroting1136953garroting
gauming11319713gaum__ing
gemmating1576443gemmating
gemming13289153gemm__ing
gumming133810193gumm__ing
hammering1737633hammering
hamming153014093hamm__ing
imponing1338773_imponing
jamming19329793jamm__ing
jargoning1845983jargoning
jawboning22133413jawboning
lamming123014583lamm__ing
lampooning1543533lampooning
mamboing1535973mambo_ing
mammering1337333mammering
mammocking2052393mammocking
mammonism11144973mammonism
mammonist12227143mammonist
marooning1238593marooning
masoning1139763ma_soning
mooning103415553__mooning
pardoning1338763pardoning
ramming123115063ramm__ing
rationing1039783rationing
ratooning1037173ratooning
summonsing1543093summonsing
vamoosing1543653vamoosing
vamosing1435593va_mosing
waggoning1543593waggoning
wagoning1336923wa_goning
wantoning1337083wantoning
yammering1735193yammering

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 Filter1786911486410.440406115.9
2DLD Change Limit148641756.93621430.4
3Display Results75750.0302500.0
 (SQL Overall)178691757.40624127.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.