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

117 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
unhorsing133685(None) 
unhousing1335881unhousing
endorsing1147302endorsing
horsing113215582__horsing
indorsing1137142indorsing
uncorking1637402uncorking
unhooding1435892unhooding
unhooking1735352unhooking
unloosing1036112unloosing
abhorring1543543abhorring
anchoring1548323anchor_ing
aphorising1645743aphorising
authoring1348583author_ing
authorising1565013authorising
choosing142010133_choosing
chording15410153_chording
choring133617663_chor_ing
chorusing15246113_chorusing
chousing14259423_chousing
chowsing17217343_chowsing
cohousing1535283cohousing
dehorning1455243dehorning
dehorting1447213dehorting
encoring11312173encor_ing
enforcing1545473enforcing
engorging1244873engorging
exhorting2045733exhorting
hoising113414413__hoising
hording123517053__hording
horning113015003__horning
hosing103421103__ho_sing
housing113316523__housing
incorpsing1544433incorpsing
informing1537023informing
inhering12913713inher_ing
inholding1445113inholding
intorting10311413intorting
inversing1389623inversing
noising83615173_n_oising
nonhousing1444513nonhousing
noosing83315053_n_oosing
nosing73419843_n_o_sing
nursing84012553_n_ursing
rehousing1337253rehousing
shoring112820073_shor_ing
shorting122514803_shorting
snoring83917203sn_or_ing
snorting92613373sn_orting
thorning1237513_thorning
unamusing1254203unamusing
unarming1138623un_arming
unbarring1236063unbarring
unbolting1236453unbolting
unbowing1436993unbo_wing
unboxing1836113unbo_xing
uncaring11312843uncar_ing
uncasing11511003un_casing
unceasing1239653unceasing
uncharging1744393uncharging
uncharming1844523uncharming
unchoking1935703uncho_king
unclosing1247753unclosing
uncoating12611923uncoating
uncocking1836233uncocking
uncoiling1238993uncoiling
uncrossing1345203uncrossing
uncurbing1455513uncurbing
uncurling1237113uncurling
undaring10412753undar_ing
underling111514613underling
undersign1177113undersign
undersong1147993undersong
underusing1247263underusing
underwing141410883underwing
undocking1735653undocking
undoing9312243undo__ing
unerring9311273un_erring
unfolding1436063unfolding
unfurling1335763unfurling
ungirding1245153ungirding
unhairing1335953unhairing
unhanding1437203unhanding
unhanging1436363unhanging
unhatting1335873unhatting
unheeding1446103unheeding
unhelming1535493unhelming
unhinging1436093unhinging
unhorse1038583unhors__e
unhorsed1238833unhors_ed
unhorses1138453unhors_es
unhusking1744093unhusking
uniforming1643793uniforming
unionising1145483unionising
unloading1137193unloading
unlocking1636073unlocking
unloving1277483unlo_ving
unmolding1335823unmolding
unmooring1255813unmooring
unmortising1453243unmortising
unmoving1436253unmo_ving
unnerving1336633unnerving
unrobing1138063unro_bing
unrolling1078563unrolling
unroofing1385703unroofing
unrooting1098833unrooting
unstring9312093unstr_ing
unthroning1445493unthroning
untiring9312003untir_ing
unvarying1644503unvarying
unvoicing1545083unvoicing
unyoking1636183unyo_king
uphoarding1742723uphoarding
upholding1643373upholding
uprousing1235623uprousing
uptossing1243523uptossing
ushering1258923usher_ing
whoring142910293_whor_ing

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.1561145455.1
2DLD Change Limit1486411176.87321626.8
3Display Results1171170.0631857.1
 (SQL Overall)1786911177.09225196.1
 
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.