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

111 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
maligned128577(None) 
aligned9128551_aligned
maligner11115331maligner
aliened81011742_aliened
aligner8108312_aligner
alined75221402_ali_ned
malign939852malign__
maligners12104782maligners
malignly1444682malignly
maligns1038132malign_s
maline84529082mali_ne_
malines93625602mali_nes
malinger11116532malinger
margined1237742margined
misaligned1443582misaligned
realigned1145332realigned
unaligned1144872unaligned
alibied1038143_alibied
alienee71013153_alienee
aliener71011193_aliener
alighted1347673_alighted
align65016503_align__
aligners9117573_aligners
aligns75312953_align_s
aline57243153_ali_ne_
aliner65621983_ali_ner
alines65735223_ali_nes
aliped95414283_ali_ped
aliunde835003_aliunde
assigned1044633assigned
basined10310003basi_ned
bylined1335853byli_ned
cabined1239993cabi_ned
cairned1037643ca_irned
calcined1338743calcined
calibred1335053calibred
clinged113310093_clinged
coigned11418663_coigned
cologned1237153cologned
cosigned1235723cosigned
deigned1037503_deigned
designed1136943designed
eloigned1043423eloigned
fatigued1342943fatigued
feigned1245353_feigned
gained84617463ga_i_ned
imagined1254783imagi_ned
limned94811473__limned
lined64934643__li_ned
machined1637303machined
maddened1334893maddened
magicked1842963magicked
magnet9320663ma__gnet
maigre9309163ma_igre_
mailed95326753ma_i_led
maimed114812663ma_i_med
mainlined1254353mainli_ned
malfed12369763mal__fed
malgre9299303mal_gre_
malice104818483mali_ce_
malices114316623mali_ces
malignant1245223malignant
maligning13145583maligning
malignity1543653malignity
malingered1442713malingered
malingers1285853malingers
malled94626113mal__led
malposed1344563malposed
malted94819863mal__ted
managed113212603manag_ed
maned86634103ma___ned
mangled113615263ma_ngled
manned94418643ma__nned
marigold1244093marigold
marine84230403mari_ne_
mariner93315993mari_ner
marines93928013mari_nes
marline93320953marli_ne_
marlines103818713marli_nes
marooned1138563marooned
masoned1039803ma_soned
matinee92415613mati_nee
mildened1235773mildened
mined85333353m__i_ned
moline84422033moli_ne_
motioned1137453motioned
mullioned1245733mullioned
mutined103311353muti_ned
nonaligned1252933nonaligned
obliged1134983oblig_ed
pained95622853pa_i_ned
patined105114783pati_ned
plained103812233plai_ned
rained75024603ra_i_ned
rationed9410093rationed
ravined115411823ravi_ned
reigned949213_reigned
relined85321933reli_ned
resigned1038863resigned
sained75424243sa_i_ned
salified12310363salified
saline65132703sali_ne_
salines74029413sali_nes
signed83413753__signed
splined105013113spli_ned
taliped1078203tali_ped
taloned8310223tal_oned
unlined82515803unli_ned
unsigned1037563unsigned
valine94623093vali_ne_
valines104520213vali_nes

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.1701051123.5
2DLD Change Limit1461621117.59319249.6
3Display Results1111110.0502220.0
 (SQL Overall)1786911117.81322871.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.