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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
gurge7541978(None) 
gorge76423891gorge
gurged95513361gurged
gurges84716861gurges
gurgle83912471gurgle
purge85324601purge
surge65027691surge
urge54722421_urge
aurae54128112aurae
barge85631022barge
budge94619882budge
bulge86419872bulge
burg74930362burg_
burgee97120592burgee
burger94020792burger
burgh115216032burgh
burgle94815862burgle
burgs84924092burgs
burke115122762burke
burse75527252burse
cure66149122cur_e
curie74533042curie
curse75829142curse
curve104920022curve
dirge75117072dirge
dure56341812dur_e
forge95126942forge
fudge105315532fudge
furze176815812furze
gage65936102g_age
garage8314512garage
garget84327272garget
gargle84215462gargle
gauge76117902gauge
gore55744962gor_e
gorged95016982gorged
gorger86116982gorger
gorges85321892gorges
gorget87123862gorget
gorse65926812gorse
gouge78220062gouge
gourde8107932gourde
gree56641562g_ree
grudge9388582grudge
grue55825712g_rue
grume86218162grume
grunge8359582grunge
gude65423332gu_de
guggle94110432guggle
guide75019882guide
guile64521132guile
guise64717712guise
gurgled10399122gurgled
gurgles94312872gurgles
gurglet94412032gurglet
gurnet74920872gurnet
gurney10429412gurney
gurry94515412gurry
gursh94512332gursh
guru54623912gur_u
gurus64318192gurus
gyre84722762gyr_e
huge86321652hu_ge
judge144714162judge
large65325462large
luge55531642lu_ge
lunge65323802lunge
lure45142462lur_e
marge85328332marge
merge84523692merge
mure65941332mur_e
murre74821072murre
nudge74616432nudge
nurse54420122nurse
ourie54027302ourie
parge85831852parge
pure65543332pur_e
puree74632842puree
purged104918262purged
purger94717232purger
purges94421762purges
purse76028892purse
sarge65531132sarge
serge64727472serge
spurge93711322spurge
sure45447412sur_e
surged84118882surged
surger74320092surger
surges73924592surges
surgy95118522surgy
targe65227092targe
urged75316032_urged
urger64116472_urger
urges64619912_urges
verge93419842verge

Search took 2 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.310576422.6
2DLD Change Limit53800951.58034050.6
3Display Results95950.0303166.7
 (SQL Overall)178691951.92093068.2
 
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.