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

92 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
galago838912galago
garage8314512garage
gavages1237682gavages
lavage1038262lavage
ravage1039302ravage
savage10410172savage
adage7414053_adage
ava610139323_ava__
avail8313883_avail
avant86224663_avant
avast85519363_avast
avgas96912133_avgas
damage10410783damage
fava106820263fava__
favas115618593fava_s
gaff114828153g__aff
gag57753633g__ag_
gaga66625553g__aga
gagaku1243813gagaku
gage65936103g__age
gags66441063g__ags
gala55635163gala__
galagos938153galagos
galah95917643gala_h
galahs105512683galahs
galanga936023galanga
galas65731643gala_s
galax135314463gala_x
galaxy17476313galaxy
gama77035523gama__
gamas85431363gama_s
gamay116419113gama_y
gamays126310913gamays
ganef96322463ga_nef
gang66031973ga_ng_
gangs76222573ga_ngs
ganof95420363ga_nof
garaged1039253garaged
garages9314113garages
garbage1138053garbage
garbagy1444243garbagy
gasbag1035413gasbag_
gasbags1135473gasbags
gauge76117903ga_uge
gave84634053gav__e
gavel95815183gav_el
gavels105911093gavels
gavial10310083gavial
gavials1136603gavials
gavot9321123gav_ot
gavots1038113gavots
gayal9312713gaya_l
gayals1039513gayals
gazabo1834833gazabo
gazar154612983gaza_r
gazars164811553gazars
guava938583guava__
guavas1037163guava_s
gulag7310823gulag_
gulags837543gulags
haaf106227733ha_a_f
java147316643java__
javas155915423java_s
kava115819703kava__
kavas125919953kava_s
kavass13517303kavass
lava76725423lava__
lavabo1135273lavabo
lavages1138603lavages
lavas85422223lava_s
lavash12597373lavash
lovage1037353lovage
manage93818903manage
navaid1037653navaid
naval85315833nava_l
navar83912733nava_r
navars92810573navars
pavan106518473pava_n
pavane114113443pavane
pavans115715593pavans
ravaged1236493ravaged
ravager1136563ravager
ravages1139403ravages
rivage1038843rivage
salvage1138193salvage
savaged1236993savaged
savager1137133savager
savages1139973savages
savant9416043savant
savate9313783savate
vagi86719363__vagi

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit112716924.62324381.6
3Display Results92920.0332787.9
 (SQL Overall)178691925.03235510.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.