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 “multiped” 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
multiped133737(None) 
multipede1445961multipede
multipeds1445651multipeds
milliped1337382milliped
multifid1445832multifid
multihued1544512multihued
multijet1749552multijet
multipaned15105962multipaned
multipedes1545632multipedes
multiple12118302multiple
multiples13118112multiples
multiplet13108952multiplet
multiplex20105842multiplex
multiplied1545812multiplied
multiply15106612multiply
multispeed1543772multispeed
mutined103311352mu_tined
aliped95414283_al_iped
bullied104514813bulli_ed
cullied104012353culli_ed
cultigen1143813cultigen
cultured1137233cultured
filliped1435223filliped
fulmined1454333fulmined
gullied93812063gulli_ed
gulped104610373gul__ped
juttied15417863jutti_ed
malted94819853malt__ed
maltier93015483malti_er
melted94219063melt__ed
milleped1335173milleped
millipede1444223millipede
millipeds1444703millipeds
milted93919943milt__ed
miltier93214963milti_er
mistimed1339123mistimed
mistyped1685173mistyped
molted94217473molt__ed
morticed1377163morticed
mortised1178743mortised
motived13357763m_otived
moulted103310313moult__ed
muddied12339213muddi_ed
mulched15307763mul_ched
mulcted12296693mul_cted
muled85824433mul___ed
mulled94721553mul__led
mullioned1245733mullioned
mullite9313013mullite_
mullites10411643mullites
multiage1147983multiage
multiarmed1554643multiarmed
multiband1444513multiband
multicar1247523multicar
multicell1345523multicell
multiday1445423multiday
multifold1544463multifold
multigerm1444443multigerm
multigrid1344383multigrid
multilobed1544203multilobed
multimedia1553573multimedia
multimode1445753multimode
multipack1944643multipack
multipage1446453multipage
multipara1345993multipara
multipart1347513multipart
multipath1646053multipath
multipiece1655163multipiece
multipion1346103multipion
multiplets1496103multiplets
multiplexed2363773multiplexed
multiplier1445833multiplier
multiplies1446823multiplies
multipole1347063multipole
multipoles1446563multipoles
multiport1347213multiport
multipower1744993multipower
multisided1444473multisided
multistep1344573multistep
multiton1087343multiton
multitude1246143multitude
multiuse1046513multiuse
multiuser1144983multiuser
multiyear1444353multiyear
multure939183multure_
multures1039333multures
mummied11327103mummi_ed
mumped133813163mu__mped
musted93321073must__ed
mustered112511503mustered
mustier94017953musti_er
mutated102712253mu_tated
muted85023383mu_t__ed
mutine84420373mu_tine_
mutines93117823mu_tines
mutinied1148153mu_tinied
muttered112610793muttered
outlined92512953outlined
outlived12269583outlived
outsped101110323ou_tsped
plumiped1533313plumiped
poulticed1443433poulticed
pulped114612533pul__ped
puttied103811163putti_ed
sliped95417063_sl_iped
stiped94517073__stiped
sullied83714483sulli_ed
taliped1078203tal_iped
untied73720813_unti_ed
untimed102713363_untimed
untipped1335763_untipped
untired82316383_untired

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621127.34319904.9
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.56223630.1
 
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.