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

131 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
houseling133748(None) 
houselling1445751houselling
counseling1345462counseling
hanseling1338062hanseling
hirseling1396272hirseling
hoseying1537192ho_seying
hosteling1337892hosteling
housing113316522hous__ing
hoveling15189592ho_veling
hustling12228792h_ustling
morseling1238072morseling
tousling938792tous_ling
bousing103718043bous__ing
boweling143410683bo_weling
busheling1535503_busheling
bustling112110063_bustling
chiseling1536403chiseling
chousing14259423chous__ing
consoling12310873consoling
corbeling1439033corbeling
corseting12312173corseting
cosseting1239543cosseting
counselings1442713counselings
counselling1444403counselling
coupling13310783cou_pling
cupeling1338863_cupeling
dieseling1146143dieseling
doubling1238153dou_bling
dousing93315763dous__ing
doweling13279763do_weling
dueling93614543_du_eling
fouling113315373fou__ling
foundling1435213foundling
fueling113615133_fu_eling
gosling93312403go_s_ling
grueling1078273gru_eling
handseling1544323handseling
hanselling1445623hanselling
hassling1236803h_assling
hauling113714433hau__ling
heeling113618513h__eeling
hireling121210993h_ireling
hirselling1444833hirselling
hirsling1277543hirs_ling
hoarsening1444403hoarsening
hobbling16227583ho_bbling
hocusing1446583hocus__ing
hocussing1544093hocus_sing
hoeing104117023ho__e_ing
hoidening1435633hoidening
hoising113414413hois__ing
hoisting123610903hois_ting
holing104025073ho___ling
hollering1337743hollering
holstering1447083holstering
homering141512073ho_mering
hondling132210013ho_ndling
honeying1537673ho_neying
hoovering1635753hoovering
hoppling16206763ho_ppling
horselike1646263horselike
horsemint1447123horsemint
horsing113215583hors__ing
hoselike15179643ho_selike
hosing103421103ho_s__ing
hostelling1446163hostelling
hosting114318383ho_s_ting
hounding132610053hou_nding
hourlong1242733hou_rlong
houseflies1644753houseflies
housel95217043housel___
houseled1237283housel_ed
houseleek1643943houseleek
houseless1237463houseless
houselled1346193houselled
housels105312133housel__s
houseman1346573houseman_
housemen1346563housemen_
houseplant1553933houseplant
housesit1177093housesi_t
housesits1244843housesits
housewife18113733housewife
housings12307483hous__ings
hovelling1636163hovelling
hovering151911143ho_vering
howling143413163ho__wling
hoydening1744353hoydening
huddling14227293h_uddling
hulling113619013h_u_lling
humbling16208673h_umbling
hurdling13288013h_urdling
hurling113616413h_u_rling
hurtling12318313h_urtling
hushing144514473h_us_hing
husking154312053h_us_king
jostling16207123jo_stling
jousting16309353jous_ting
justling16207253_justling
laureling1035643laureling
loosening1044933loosening
loudening1144743loudening
lousing83817733lous__ing
modeling12311073mo_deling
morselling1346323morselling
moseying1436853mo_seying
mouselike1545013mouselike
mousing103816273mous__ing
mousseline1253063mousseline
moussing1138143mous_sing
muscling1337853_muscling
ousting84021353_ous_ting
outseeing1038333_outseeing
outselling1188023_outselling
pommeling1643873pommeling
rousing83920553rous__ing
rousting93913273rous_ting
roweling122811123ro_weling
rustling9249983_rustling
shoveling1635553sho_veling
sousing83517823sous__ing
tasseling1035853tasseling
teaseling1036913teaseling
tinseling1036643tinseling
tousing82916993tous__ing
touzling1835503tou_zling
toweling122910373to_weling
tussling935823_tussling
weaseling1335613weaseling
worsening1345553worsening
yodeling1357673yo_deling
youngling1463273youngling

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.420425454.8
2DLD Change Limit1486411317.09320956.0
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.55923639.5
 
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.