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

112 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
mortaring123794(None) 
martyring1535782martyring
montaging1346542montaging
mortgaging1542892mortgaging
morticing1448012morticing
mortising1238692mortising
motoring11410952mo_toring
portaging1346842portaging
portering122012302portering
torturing1036252torturing
amortising1345973amortising
amortizing2246403amortizing
bartering122313643bartering
borating113414503bor_ating
bordering1338833bordering
collaring12310563collaring
comparing162410583comparing
cornering12311893cornering
corotating1349323corotating
corrading1338203corrading
costarring1345393costarring
doctoring1346183doctoring
dogearing1235763dogearing
foraging1358063for_aging
foraying1537433for_aying
forbearing1644803forbearing
forearming1644193forearming
forsaking1745173forsaking
fortuning1345493fortuning
forwarding1843493forwarding
fostering132411263fostering
gartering112111573gartering
loitering1039683loitering
margarin1148073margarin_
margarine1247713margarine
margarins1248293margarins
marring103319553mar__ring
marting103325013mart__ing
mastering122315303mastering
mattering122314053mattering
maturing1139963m_aturing
mentoring1239543mentoring
metaling111613723m_etaling
metering112915633m_etering
metring103215293m_et_ring
mirroring1246193mirroring
mistaking1699693mistaking
mitering113015403m_itering
mitring103514143m_it_ring
moaning103714443mo__aning
moating104218153mo__ating
moldering1367863moldering
molting103517173molt__ing
mongering13310353mongering
monitoring1346233monitoring
mooring102514443mo__oring
mooting103019363moot__ing
moraine9314573mor_a_ine
mordanting1444003mordanting
morning103215043mor__ning
morphing1637553mor_phing
morseling1238073morseling
mortality1467733mortality
mortar83812043mortar___
mortared1137213mortar_ed
mortarman1343213mortarman
mortarmen1343213mortarmen
mortars93411523mortar__s
mortary12369043mortar__y
mortifying1944923mortifying
mortmain1244573mortmain_
mortmains1344493mortmains
mortuaries1245373mortuaries
mothering152110183mothering
motiving1437163mo_tiving
motorings1245973mo_torings
mottling11197753mo_ttling
mouthing142810243mout_hing
murdering1357133murdering
murmuring1443633murmuring
murthering1644473murthering
mustering122212333mustering
mutating112211753m_utating
muttering122611323muttering
northing12199063nort_hing
notating92513343no_tating
nurturing1045013nurturing
oaring74225303_o__aring
orating83520323_or_ating
ordering1039353_ordering
outdaring1179723_outdaring
outring84021023_out_ring
partaking1698673partaking
porting103021783port__ing
portraying1645163portraying
posturing1238993posturing
pottering122612003pottering
raring74332873__r_aring
rearing83128783__rearing
roaring82916003__roaring
rotating92614553ro_tating
soaring83521893so__aring
sortieing1046163sortieing
sorting83221813sort__ing
staring84527053__staring
surtaxing1784143surtaxing
taring73932283___taring
totaling9610303to_taling
tottering10229613tottering
uprearing1238373uprearing
upstaring1235963upstaring
worthing15178053wort_hing

Search took 9 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.423422437.4
2DLD Change Limit1486411127.51319784.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.98222386.7
 
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.