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

103 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
honouring133688(None) 
honoring12310471hono_ring
colouring1258732colouring
conjuring1937912conjuring
contouring1347012contouring
humouring1544552humouring
nonjuring1756052nonjuring
tonsuring1046502tonsuring
armouring1244983armouring
censuring1237603censuring
clouring112811273_clouring
coenduring1444233coenduring
cohousing1535283cohousing
coinsuring1345373coinsuring
coloring11414843colo_ring
concurring1546603concurring
conducing1537693conducing
confusing1537333confusing
confuting1539093confuting
conquering2246273conquering
consuming1437913consuming
contusing1239143contusing
detouring1136973detouring
devouring1435953devouring
enduring10310013_enduring
ensuring9310173_ensuring
enuring8813883_en_uring
favouring1644023favouring
flouring123010143_flouring
fondueing1443093fondueing
fonduing13245893fondu_ing
hachuring1845123hachuring
hangaring1438033hangaring
hankering17239383hankering
harbouring1643603harbouring
hindering14310273hindering
hobnobbing1751003hobnobbing
hoboing13309453hobo__ing
hocusing1446583ho_cusing
hollering1337743hollering
holocrine1495343holocrine
homering141512073ho_mering
honchoing1844873honchoing
hondling132210013hon_dling
honeying1537673hon_eying
hongiing1335603hon_giing
honing103421503hon___ing
honking153414793hon__king
honorand1246333hono_rand
honour94710863honour___
honoured1236313honour_ed
honourer1146243honour_er
honourers1245573honourers
honours10339373honour__s
hooding123815203ho_o_ding
hoofing143912553ho_o_fing
hooking153716693ho_o_king
hooping133615703ho_o_ping
hooting113919883ho_o_ting
hoovering1635753hoovering
hothousing1742923hothousing
housing113316523h__ousing
hovering151911143ho_vering
humoring1456853humo_ring
hungering14187683hungering
hunkering17227123hunkering
ignoring1036483igno_ring
injuring1637473_injuring
inpouring1236393inpouring
insuring9311153_insuring
inuring81213013_in_uring
jointuring1843233jointuring
knouting13226793_knouting
labouring1236213labouring
louring83916503__louring
manuring1139223man_uring
minoring11311473mino_ring
mongering13310353mongering
mooring102514443mo_o_ring
motoring11410953moto_ring
nonbuying1543953nonbuying
nonhousing1444513nonhousing
nonruling1046433nonruling
nonusing939233non_using
pondering132411333pondering
posturing1238993posturing
pouring103115863__pouring
repouring12310073repouring
rumouring1244513rumouring
savouring1335193savouring
scouring112810853_scouring
snoring83917203_sno_ring
snouting92511923_snouting
sojourning1841713sojourning
souring83219063__souring
tabouring1245723tabouring
tenuring938863ten_uring
tonguing1046263tongu_ing
torturing1036253torturing
touring82915193__touring
vapouring1544653vapouring
venturing1337553venturing
wondering142110463wondering

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411036.78321913.8
3Display Results1031030.0432395.3
 (SQL Overall)1786911037.27924548.8
 
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.