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

86 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
honourer114624(None) 
honorer1039671hono_rer
honoured1236311honoured
honourers1245571honourers
colourer1037562colourer
conjurer17117682conjurer
honored11310122hono_red
honoree10412112hono_ree
honorers1139262hono_rers
honour94710862honou__r
honours10339372honour_s
armourer1054883armourer
censurer10228133censurer
coinsurer1144773coinsurer
colorer9312523colo_rer
coloured1148313coloured
colourers1136473colourers
conducer13127373conducer
confuter1338513confuter
conjure16109073conjure_
conjured18117903conjured
conjurers18126233conjurers
conjures17119913conjures
conjuror17144633conjuror
conquer1838623conqu_er
conquerer2044723conquerer
consumer1238503consumer
contoured1237303contoured
devourer1235063devourer
dourer74215273__dourer
endurer83210363_endurer
ensurer73011903_ensurer
favourer1443823favourer
hankerer15248233hankerer
hinderer1238273hinderer
hobnobber1551173hobnobber
honer85332093hon___er
honester1139713honester
honker134117463hon__ker
honor85718623hono___r
honorary1445803hono_rary
honorees1148773honorees
honors94816793hono_r_s
honouring1336883honouring
hoodier113812973ho_odier
hoofer124014953ho_o_fer
hooker134820173ho_o_ker
hookier143811673ho_okier
hooper114518313ho_o_per
hooter94123933ho_o_ter
hootier104915353ho_otier
hoover124314433ho_o_ver
houser95322283h__ouser
hoverer13319823ho_verer
humoured1444363humoured
ignorer8276103igno_rer
injurer14318473_injurer
insurer73312803_insurer
ionomer939833iono_mer
labourer1045753labourer
manurer938583man_urer
monomer11311893mono_mer
nonjuror15113803nonjuror
nonowner1145253nonowner
nonuser7299143non_user
ponderer112410193ponderer
poorer82613993po_o_rer
posturer1038923posturer
pourer84516043__pourer
rondure837313rondure_
rondures937713rondures
savourer1134473savourer
scourer93910433_scourer
shnorrer1143523shnorrer
snorer64316763_sno_rer
sojourner1661713sojourner
sourer63620213__sourer
tabourer1035743tabourer
tonsure758783tonsure_
tonsured976383tonsured
tonsures869133tonsures
torturer835493torturer
tourer64115073__tourer
vapourer1344263vapourer
venturer1137243venturer
wonderer12249183wonderer

Search took 9 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 Filter1786911461620.456391866.2
2DLD Change Limit146162868.15317927.4
3Display Results86860.0332606.1
 (SQL Overall)178691868.64220677.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.