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

76 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
honor8571862(None) 
donor64418191donor
honer85332091honer
honors94816791honors
honour94710861honour
boner75133082boner
boor66130682bo_or
color76123742color
condor94616972condor
dolor67617962dolor
donors75115792donors
door56928512do_or
goner66025162goner
gonof95218652gonof
hoar76729162ho_ar
hobnob1335132hobnob
hobo97026082hobo_
hobos106321352hobos
hoer76533982ho_er
homer105828452homer
homo96126472homo_
homos105921782homos
hon67759382hon__
honan85319772honan
honda9414982honda
hone77549322hon_e
honed95332262honed
honers94324972honers
hones88144492hones
honey115629912honey
hong85833952hon_g
hongi96715872hongi
hongs95126202hongs
honk116931192hon_k
honker134117462honker
honks125124522honks
honky156218522honky
honored11310122honored
honoree10412112honoree
honorer1039672honorer
honours10339372honours
hons77350782hon_s
hood85132332ho_od
hoof106036582ho_of
hook116133282ho_ok
hoop96129982ho_op
hoot75752102ho_ot
hoper105829142hoper
horror988722horror
hoser811529762hoser
hour75827312ho_ur
hover115524132hover
humor101110512humor
kronor10417232kronor
loner55431042loner
manor78023922manor
minor74920062minor
mono66036712mono_
monos75930862monos
moor66628552mo_or
motor75317292motor
nor38048822__nor
odor55718092_odor
ono36838032_ono_
onos46229002_onos
phono104917022phono_
phonon114012032phonon
phonos114114792phonos
poor65630222po_or
rotor55519732rotor
senor53822792senor
sonar56523422sonar
sopor74016492sopor
tenor53620252tenor
toner55336242toner
zoner144520342zoner

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.0762351197.4
2DLD Change Limit53800761.56334421.0
3Display Results76760.0135846.2
 (SQL Overall)178691761.652108166.5
 
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.