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 “marshalling” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
marshalling175321(None) 
marshaling1645081marsha_ling
marcelling1545593mar_celling
marshalcies1851563marshalcies
marshall1345483marshall___
marshalled1642543marshall_ed
marshalls1444833marshall__s
marvelling1645363mar_velling
miscalling1547863m_iscalling
morselling1346323mors_elling
appalling1444924_a_ppalling
archaising1645104_archaising
archaizing2545224_archaizing
ashlaring1344494_a_shlaring
asphalting1643384_asphalting
assailing1036024_a_ssailing
backhauling2352814backhauling
barehanding1873484barehanding
barrelling1345454bar_relling
bushelling1644064_bushelling
caballing1436884ca__balling
canalling1239554ca__nalling
caracolling1643034caracolling
carolling1259414car__olling
catcalling1545124ca_tcalling
corralling1345434cor_ralling
drywalling1842234_drywalling
earthling1346194earth__ling
farewelling1842624farewelling
fireballing1742644fireballing
forestalling1653634forestalling
hanselling1445624hans_elling
harshening1744174harsh_ening
hatchelling2052624hatchelling
hirselling1444834hirs_elling
installing1146404_installing
lateralling1244634lateralling
malling103623664m____alling
manacling1446284ma__nacling
manhandling1852274ma_nhandling
marauding1344984mar__auding
marbling13179884mar___bling
marching164312194march___ing
marinading1445614marina_ding
marinating13410264marina_ting
marling103322764mar____ling
marshal1238974marsha_l___
marshalcy1951774marsha_l_cy
marshaled1544644marsha_l_ed
marshals1337784marsha_l__s
marshalship21102774marshalship
marshalships22132444marshalships
marshland1543354marsh__land
marshlike1843904marsh__like
marshmallow215684marshmall_ow
marshmallows226614marshmallows
marshmallowy256504marshmallowy
marveling1537104mar__veling
mascaraing1544254ma_scaraing
mashing134422244ma_sh___ing
massacring1543594ma_ssacring
massaging1346354ma_ssa_ging
medalling1346924m__edalling
merchanting1944314merchanting
metalling1249594m__etalling
misallying1644314m_is_allying
misbilling1545544m_isbilling
misdialling1543304misdialling
mishandling1843334m_ishandling
misshaping1844394missha_ping
misspelling1643754misspelling
misvaluing1684604m_isvaluing
morseling1238074mors__eling
mothballing1952314mothballing
parasailing1444334parasailing
parcelling1546174par_celling
recalling122211904__recalling
refalling132010424__refalling
rivalling1335964__rivalling
sandalling1245874sa_ndalling
sashaying1644594sa_sha_ying
shauling1249394___shauling
shawling1558224___shawling
shelling123515214___shelling
shilling123315384___shilling
spalling113213464___spalling
stalling95116704___stalling
tasselling1145234ta_sselling
thralling13256834thr__alling
unshelling1445594_unshelling
warsling12198594wars___ling
warstling1335064wars__tling
wassailing1443594wa_ssailing

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819938.89016740.0
3Display Results93930.0462021.7
 (SQL Overall)178691939.35919093.0
 
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.