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

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

58 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
malodor104456(None) 
malodors1144971malodors
matador1066252matador
alder65421913_al_der
aldol61212333_al_dol
algor6513053_al_gor
alodia71112453_alodia
aloof83521573_alo_of
ardor64617863_a_rdor
balder95318863bal_der
caloyer1238143caloyer
candor94516423ca_ndor
floor84215233_flo_or
galoot72719163galo_ot
halidom1386453halidom
machzor2344263machzor
madder103515593ma_dder
mahzor2035113ma_hzor
major145212923ma__jor
malady1237863malad_y
malar76424443mal__ar
malison939693malison
mallow114014743mal_low
malmier113611953malmier
malodorous1352653malodorous
maloti8313213malo_ti
maltier93015483maltier
maltol8310843mal_tol
manor78023933ma__nor
markhor1635463markhor
maroon83118203maro_on
mastodon1144383mastodon
matadors1156983matadors
maunder10328693maunder
mayor106616623ma__yor
melder93915813mel_der
melodeon1143443melodeon
melodia1038883melodia
melodic1238543melodic
melody1237203melod_y
milder93818453mil_der
mirador1046503mirador
molder93819273mol_der
moor66628553m__o_or
motor75317293m__otor
odor55718093___odor
pallor8313683pal_lor
pandoor10358583pandoor
parador103311413parador
parodoi10267723parodoi
parodos103011753parodos
saloon64418023salo_on
saloop84212583salo_op
salvor94711093sal_vor
tandoor8278563tandoor
valor83614893val__or
valour93010373valo_ur
weldor10317653wel_dor

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 Filter1786911340270.830215290.4
2DLD Change Limit134027588.11016526.1
3Display Results58580.0134461.5
 (SQL Overall)178691588.95319958.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.