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

96 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
gavage1137191gavage_
gavages1237681gavages
gadget93616182ga_dget
garage8314512garage_
garaged1039252garaged
garages9314112garages
garget84327272ga_rget
lavage1038262lavage_
lavages1138602lavages
ravage1039302ravage_
ravaged1236492ravaged
ravager1136562ravager
ravages1139402ravages
savage10410172savage_
savaged1236992savaged
savager1137132savager
savages1139972savages
savagest1245762savagest
adage7414053_adage_
adages8412953_adages
avant86224663_ava_nt
avast85519363_ava_st
avaunt959603_avaunt
avocet11412683_avocet
avoset9315673_avoset
cabaret112519043cabaret
damage10410773damage_
damaged1257453damaged
damager1157973damager
damages11511273damages
gadgets10348683ga_dgets
gadgety13356163ga_dgety
gage65936103g__age_
gaged85522313g__aged
gager74726293g__ager
gages74529973g__ages
gagged104817153ga_gged
gagger95016513ga_gger
galago838903galag_o
galagos938143galagos
galatea839953galatea
galaxes1538873galaxes
gallet73630853ga_llet
ganged94619193ga_nged
ganger83721463ga_nger
gannet74321853ga_nnet
gantlet83616243gantlet
garbage1138053garbage_
garbages1238183garbages
garbagey1543373garbagey
gargets94614573ga_rgets
gargety12388043ga_rgety
garnet73928413ga_rnet
garret74426553ga_rret
gasket114417253ga_sket
gauge76117903ga_uge_
gauged94713473ga_uged
gauger84714853ga_uger
gauges85915993ga_uges
gave84634053gav__e_
gavel95815183gav__el
gaveled12399133gaveled
gavot9321123gav__ot
gavotte1174603gavotte
gorget87123863g_orget
gravamen1443933gravamen
laager74312783la_ager
lazaret16411783lazaret
lovage1037353lovage_
lovages1138033lovages
manage93818903manage_
managed113212603managed
manager103413583manager
manages103418963manages
parapet11317643parapet
parget94529393pa_rget
pavane114113443pavane_
pavanes123612653pavanes
ravagers1235583ravagers
rivage1038843rivage_
rivages1138873rivages
salvage1138193salvage_
salvaged1335363salvaged
salvagee1246483salvagee
salvager1235593salvager
salvages1238123salvages
savagely1543343savagely
savagery1543223savagery
savant9416043sava_nt
savate9313783savate_
savates10312953savates
tabaret92717313tabaret
tanager83010943tanager
target75028903ta_rget
valet84337873__valet
wavelet13310943wavelet

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 Filter1786911340270.423422437.4
2DLD Change Limit134027966.76619808.9
3Display Results96960.0303200.0
 (SQL Overall)178691967.21924752.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.