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

110 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
unhousing133588(None) 
unhorsing1336851unhorsing
chousing14259422_chousing
cohousing1535282cohousing
housing113316522__housing
nonhousing1444512nonhousing
rehousing1337252rehousing
unamusing1254202unamusing
unhooding1435892unhooding
unhooking1735352unhooking
unhusking1744092unh_usking
unloosing1036112unloosing
uprousing1235622uprousing
arousing93811803_arousing
blousing1138793_blousing
bousing103718043__bousing
carousing1237893carousing
choosing142010133_choosing
chorusing15246113_chorusing
chowsing17217343_chowsing
cohousings1642123cohousings
delousing1136303delousing
dousing93315763__dousing
endorsing1147303endorsing
ensouling1046003ensouling
enthusing1355213enthusing
espousing1265003espousing
grousing103410453_grousing
hocusing1446583__hocusing
hoising113414413__hoising
horsing113215583__horsing
hosing103421103__ho_sing
hothousing1742923hothousing
housings12307483__housings
incusing1159953in_cusing
indorsing1137143indorsing
infusing1237893in_fusing
inholding1445113inholding
inhuming1435853inh_uming
inpouring1236393inpouring
insouling1036823insouling
knouting13226793kn_outing
lousing83817733__lousing
mousing103816273__mousing
noising83615173_n_oising
nonusing939233_nonusing
noosing83315053_n_oosing
nosing73419843_n_o_sing
rousing83920553__rousing
shouting122711793_shouting
snouting92511923sn_outing
sousing83517823__sousing
spousing11198733_spousing
thouing11258603_thou_ing
tousing82916993__tousing
unblushing1642953unblushing
unbolting1236453unbolting
unbowing1436993unbo_wing
unboxing1836113unbo_xing
uncasing11511003un_casing
unceasing1239653unceasing
unchoking1935703uncho_king
unclosing1247753unclosing
unclouding1444523unclouding
uncoating12611923uncoating
uncocking1836233uncocking
uncoiling1238993uncoiling
unconfusing1752263unconfusing
uncorking1637403uncorking
uncoupling1544463uncoupling
uncrossing1345203uncrossing
underusing1247263underusing
undocking1735653undocking
undoing9312243undo__ing
undoubling14133433undoubling
undoubting14103333undoubting
unfolding1436063unfolding
ungluing1035863unglu_ing
unhairing1335953unhairing
unhanding1437203unhanding
unhanging1436363unhanging
unhatting1335873unhatting
unheeding1446103unheeding
unhelming1535493unhelming
unhinging1436093unhinging
unhouse1038923unhous__e
unhoused1238153unhous_ed
unhouses1138703unhous_es
unhung1035283unh_u__ng
unionising1145483unionising
unloading1137193unloading
unlocking1636073unlocking
unloving1277483unlo_ving
unmolding1335823unmolding
unmooring1255813unmooring
unmoving1436253unmo_ving
unquoting1944763unquoting
unrobing1138063unro_bing
unrolling1078563unrolling
unroofing1385703unroofing
unrooting1098833unrooting
unrounding1244873unrounding
untrussing11124583untrussing
untrusting1186003untrusting
untuning937943un_tuning
unvoicing1545083unvoicing
unyoking1636183unyo_king
unyoung1184053unyou__ng
upholding1643373upholding
uptossing1243523uptossing

Search took 7 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.406440125.6
2DLD Change Limit1486411106.32623496.8
3Display Results1101100.0631746.0
 (SQL Overall)1786911106.79526297.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.