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

160 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
mountings1226616(None) 
mounting112711811mounting_
muntings11289811m_untings
amounting1236642amounting_
buntings11348772_buntings
counting113115262counting_
huntings12328052_huntings
mornings11297902morn_ings
mouldings13273952mouldings
moulting112710312moulting_
mounding123311262mounding_
mountains1146362mountain_s
mournings1243522mournings
mousings11277702mou_sings
munting103718772m_unting_
muntins92715132m_untin_s
outings84014752_ou_tings
soundings11266152soundings
accountings1652533accountings
agentings1134443agentings
antings85015583__antings
blunting11319843blunting_
boatings113710113bo_atings
bondings12369413bo_ndings
bouncing13318773bouncing_
bounding123012133bounding_
bounties10311393bounti_es
bunting103718833_bunting_
coastings12357863coastings
coatings113811843co_atings
couchings17285753couchings
countians1147323countians
counties10316273counti_es
couplings1435533couplings
coursings12235873coursings
courting112514563courting_
cunnings11357343_cunnings
cuttings11277613_cuttings
daunting103310403daunting_
demounting1444963demounting_
doubting1237373doubting_
ductings12346673_ductings
dunting93418383_dunting_
dustings10419033_dustings
flouncings1641673flouncings
flutings12357373flu_tings
fontinas1136853fo_ntinas
footings12248833fo_otings
foulings12327943fou_lings
founding133010783founding_
foundlings1542903foundlings
fountains1245283fountain_s
foxhuntings255973foxhuntings
groundings1343733groundings
grunting10269583grunting_
gunnings10346733_gunnings
haunting123510053haunting_
hornings12238363horn_ings
hounding132610053hounding_
housings12307483hou_sings
hunting114317123_hunting_
hustings12378683_hustings
jaunting16328633jaunting_
joinings16285243join_ings
jointing16248613jointing_
jottings16275193jo_ttings
jouncing18336853jouncing_
jousting16309353jousting_
loanings9348013loan_ings
longings10408563lo_ngings
lounging1036753lounging_
louting83719383lou_ting_
lunting83817743_lunting_
lutings83311053_lu_tings
mantlings12207223m_antlings
matings104516203m__atings
mattings11369673m_attings
meanings11329153mean_ings
meetings11287403m_eetings
mendings12338293m_endings
minings103912073m_in_ings
minting103020813m_inting_
minuting1139723minuting_
moaning103714443moan_ing_
moating104218153mo_ating_
modelings1335553modelings
moldings12267203mo_ldings
molting103517173mo_lting_
monotints1147503monotints
montanes101114523mo_ntanes
mooning103415553moon_ing_
moorings11257693mo_orings
mooting103019363mo_oting_
morning103215043morn_ing_
morphings1744663morphings
moshings14367323mo_shings
motorings1245963motorings
mouching163110583mouching_
moulding12258143moulding_
moulins9312703mou_lin_s
mountain1046113mountain__
mountainous1352833mountainous
mountainy1444013mountain_y
mounters103712493mount_ers
mounts84115073mount___s
mourning1156793mourning_
mousing103816273mou_sing_
moussing1138143moussing_
mouthing142810243mouthing_
moutons9410313mou_ton_s
mowings13328483mo__wings
muggings13244593m_uggings
muntin82915183m_untin__
musings10389543m_u_sings
mustangs11255973m_ustangs
musting103221073m_usting_
mutines93117823m_u_tines
muting93921523m_u_ting_
noonings9246653noon_ings
nuttings9276783_nuttings
ousting84021353_ousting_
outing74128153_ou_ting_
outrings92811053_outrings
outsings93410333_outsings
paintings12327093paintings
plantings12348403plantings
pointing112813683pointing_
poontangs1242763poontangs
postings112912303po_stings
pothuntings1751593pothuntings
pouncing13318883pouncing_
pounding123311473pounding_
poutines102415103pou_tines
pouting103519943pou_ting_
printings12268103printings
punting103318443_punting_
remounting1346673remounting_
rounding102812283rounding_
rousting93913273rousting_
routines82214363rou_tines
routing83821093rou_ting_
runnings9326913_runnings
scoutings12306143scou_tings
shunting123610423shunting_
sounding102712873sounding_
southings13246233southings
spoutings12245153spou_tings
stunting92811503stunting_
suitings9288953_suitings
taunting93510933taunting_
tintings9288713_tintings
tontines82114733to_ntines
tourings9277373tou_rings
touting84118453tou_ting_
tuftings12264323_tuftings
vaultings13233633vaultings
vaunting12338753vaunting_
wonting113214103wo_nting_
wounding13249403wounding_
younglings1561723younglings

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.1701051123.5
2DLD Change Limit1486411607.55019687.5
3Display Results1601600.0931720.4
 (SQL Overall)1786911607.81322871.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.