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 “honoree” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
honoree1041211(None) 
honored11310121honored
honorees1148771honorees
honorer1039671honorer
honor85718622honor__
honorers1139262honorers
honors94816792honor_s
honoured1236312honoured
honourer1146242honourer
bootee84323023bo_otee
botonee9311833botonee
bourree91311343bourree
cicoree1149843cicoree
colored10313473colored
colorer9312523colorer
concrete12411083concrete
condores113315643condores
conferee13613733conferee
confrere1347563confrere
congee96024473con_gee
cooee74531023co_o_ee
donee66931013don__ee
donnee74317063don_nee
donor64418193donor__
donors75115793donor_s
doolee73018953do_olee
entree61817883_entree
gobonee1077783gobonee
hiree85427803h__iree
hoarse94411323ho_arse
hoboed124511683hobo_ed
hoboes114717443hobo_es
hognose11117243hogno_se
hognoses12108133hognoses
holocene1346143holocene
hombre13309303hombr_e
hombres14369873hombres
homered133212713homered
homosex1936123homosex
hondle103914523hon_dle
hondled123510653hondled
hondles113614523hondles
hone77549323hon___e
honed95332263hon__ed
honer85332093hon__er
honers94324973honer_s
hones88144493hon__es
honey115629913hon__ey
honeybee1644243honeybee
honeyed1437773honeyed
hongied12308163hongied
hongies112716473hongies
honied104818393hon_ied
honked144517913hon_ked
honker134117463hon_ker
honkers143315233honkers
honkey165113823hon_key
honkie133011673hon_kie
honkies143015143honkies
honorable1446953honorable
honorand1246333honorand
honorary1445803honorary
honoring12310473honoring
honour94710863hono_ur
honourers1245573honourers
honours10339373honours
hooded114616743ho_oded
hoodie105116143ho_odie
hooey114926603ho_o_ey
hoofed134614893ho_ofed
hoofer124014953ho_ofer
hooked145320553ho_oked
hooker134820173ho_oker
hookey164713933ho_okey
hoolie93217783ho_olie
hooped125518183ho_oped
hooper114518313ho_oper
hoopoe11911233ho_opoe
hoorah124411113ho_orah
hooray123011373ho_oray
hooted104422663ho_oted
hooter94123933ho_oter
hooved134713123ho_oved
hoover124314433ho_over
hooves124815483ho_oves
horde94623053h__orde
horse86132653h__orse
hovered143411573hovered
hoverer13319823hoverer
humored1336723humored
hundred1237143hundred
ignore7269063ignor_e
ignored9226443ignored
ignorer8276103ignorer
ignores8269003ignores
ionogen837123ionogen
ionomer939833ionomer
ionone6313443iono_ne
ionones7313883ionones
minored10310103minored
mongrel1036333mongrel
monocle1139663monocle
monomer11311893monomer
monotreme1343943monotreme
moored93814173mo_ored
motored1039933motored
noncore9411953noncor_e
nongreen945513nongreen
nonobese1044363nonobese
nonoral7313603nonoral
odored8399223_odored
oorie53026363_o_orie
pongee94920193pon_gee
poorer82613993po_orer
senores73218113senores
shoetree1146573shoetree
snore55424953_snor_e
snored74819543_snored
snorer64316763_snorer
snores64324323_snores
soiree62919483so_iree
unfree9413203_unfree
unhonored1344413unhonored
whoopee15287513who_opee

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 Limit1340271246.86019537.5
3Display Results1241240.0462695.7
 (SQL Overall)1786911247.32924381.4
 
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.