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

58 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
gnome8421395(None) 
genome94312191genome
gnomes93812971gnomes
nome66038421_nome
agnomen1036762agnomen
anime75423202anime
anode65021032anode
anole55330372anole
anomie83215962anomie
anomy105113392anomy
biome94916992biome
brome94421972brome
come87547702_come
dome77240732_dome
game76644322g_ame
genom83716842genom_
genomes103611702genomes
genoms94412482genoms
geode7412592geode
gimme102411342gimme
glime85620192glime
globe84917012globe
glom75424382glom_
gloms85219782gloms
glove94516292glove
gloze154815982gloze
glume85120462glume
gnomic11248592gnomic
gnomon936182gnomon
gnoses76515162gnoses
gomer85220652g_omer
gone55639042g_one
goose65925902goose
gore55744962g_ore
grime85021322grime
grope84821612grope
grove95219332grove
grume86218162grume
home98042442_home
ignore7269062ignore
income10712092income
mome85239352_mome
name65637412_name
node513036882_node
nom510450642_nom_
noma67529462_noma
nomen75621622_nomen
nomes74933122_nomes
noms65636402_noms
none45743172_none
nope65934192_nope
nose46739362_nose
note46239962_note
pome85636692_pome
snore55424952snore
some66040382_some
tome67543192_tome
ugsome934782ugsome

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 Filter178691538000.1101624463.6
2DLD Change Limit53800585.36010037.3
3Display Results58580.0134461.5
 (SQL Overall)178691585.48332590.0
 
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.