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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
gauge7611790(None) 
gage65936101ga_ge
gauged94713471gauged
gauger84714851gauger
gauges85915991gauges
gauze155712971gauze
gouge78220061gouge
age47154332_a_ge
ague55725922agu_e
auger64922472_auger
badge94819692badge
barge85631022barge
cadge94018792cadge
cage75339062ca_ge
cause75225352cause
daube85015302daube
fadge104817002fadge
faugh125712962faugh
fauve114712072fauve
gable85325522gable
gadget93616182gadget
gadje1457742gadje
gae46457702ga__e
gaffe124111652gaffe
gag57753632ga_g_
gaga66625552ga_ga
gaged85522312ga_ged
gager74726292ga_ger
gages74529972ga_ges
gagged104817152gagged
gagger95016512gagger
gaggle93412622gaggle
gags66441062ga_gs
gale56347322ga_le
gambe106219212gambe
game76644322ga_me
gane55145302ga_ne
gang66031982gang_
ganged94619202ganged
ganger83721472ganger
gangs76222582gangs
gangue81310582gangue
gape75134512ga_pe
garage8314512garage
garget84327272garget
gargle84215462gargle
gate55746572ga_te
gauche1238562gauche
gaud67025432gau_d
gauds75717722gauds
gaudy106611462gaudy
gaugers94211712gaugers
gault65128482gault
gaum75726422gau_m
gaumed104610322gaumed
gaums86217072gaums
gaun56427712gau_n
gaunt65430402gaunt
gaur56723352gau_r
gaurs66317992gaurs
gauss65613452gauss
gauzes164710632gauzes
gauzy18489212gauzy
gavage1137192gavage
gave84634052ga_ve
gaze145032412ga_ze
gigue71210672gigue
glue55628492glu_e
glug66118012glug_
glugs75214282glugs
glume85120462glume
glute66020902glute
gorge76423892gorge
gouged96214592gouged
gouger86014362gouger
gouges86318692gouges
grange83716202grange
grudge9388582grudge
grue55825712gru_e
grume86218162grume
grunge8359582grunge
gude65423332g_ude
gurge75419782gurge
haugh125114052haugh
haute89521612haute
huge86321652_huge
kluge104910462kluge
large65325462large
laugh94414372laugh
luge55531642_luge
mage75739132ma_ge
mange84930202mange
marge85328332marge
mauger93813482mauger
maugre9308972maugre
mauve104013272mauve
page76036102pa_ge
parge85831852parge
pause75021832pause
rage55742352ra_ge
range64728422range
regauge945812regauge
rouge65423442rouge
sage55044592sa_ge
sarge65531132sarge
sauce75121652sauce
sauger74316252sauger
saugh95318402saugh
saute55028082saute
targe65227102targe
taupe7314172taupe
vague96513112vague
wage84834082wa_ge
waugh125411682waugh

Search took 3 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 Filter178691538000.343520965.0
2DLD Change Limit538001141.90628226.7
3Display Results1141140.0333454.5
 (SQL Overall)1786911142.28278304.6
 
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.