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

73 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
dogface145405(None) 
dogfaces1554141dogfaces
deface123113862d_eface
dogbane1135652dogbane
dogvane1243852dogvane
doughface1951702doughface
biface1358103_biface
boldface1662893boldface
boniface1543863boniface
catface1436763catface
cognac1157273cognac_
cognacs1256043cognacs
cognate10312203cognate
dace76934923d___ace
defaced142910973d_efaced
defacer132810363d_efacer
defaces133213403d_efaces
defame123212433d_efame
degage92711383deg_age
degame102713183deg_ame
deglaze1835583deglaze
degrade10229903degrade
disgrace1248283disgrace
dockage1535723dockage
dogbanes1245433dogbanes
dogcart1148043dogcart
doge66233803dog___e
dogear838193dogea_r
dogeared1145793dogeared
dogears937513dogears
dogfish15226763dogfish
doggie93910893dog_gie
doggone1035683doggone
dogie75222793dog__ie
doglike13207453doglike
dogma96112463dogma__
dogmas105011243dogma_s
dogmata1145143dogmata
dognap1035343dogna_p
dognaped1343493dognaped
dognaper1243693dognaper
dognaps1134393dognaps
dogvanes1344303dogvanes
dogwatch1841703dogwatch
dolce85816683do__lce
donate73619503do_nate
dormice1237133dormice
dosage82810003do_sage
dotage82711613do_tage
douce85518423do__uce
doughfaces2051833doughfaces
efface14366673_efface
enface112510353_enface
face96140123___face
foggage1334113foggage
foreface1647113foreface
glace87420153__glace
grace85124543__grace
hogback1945453hogback
hogmane1336343hogmane
nonfact1248893nonfact
noplace1137393noplace
office1435693_office
outface123011973outface
pomace123111913po_mace
postface1566123postface
preface14510923preface
reface113616353_reface
solace83415823so_lace
surface1238653surface
togae67020113tog_a_e
togate74515683tog_ate
uniface1236953uniface

Search took 7 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.390458182.1
2DLD Change Limit134027735.89322743.4
3Display Results73730.0302433.3
 (SQL Overall)178691736.31328305.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.