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

101 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
maligner1111533(None) 
aligner8108311_aligner
maligned1285771maligned
maligners12104781maligners
malinger11116531malinger
aliener71011192_aliener
aligned9128552_aligned
aligners9117572_aligners
aliner65621982_ali_ner
malign939852malign__
malignly1444682malignly
maligns1038132malign_s
maline84529082mali_ne_
malines93625602mali_nes
malingers1285852malingers
mariner93315992mari_ner
aginner844663_aginner
aliened81011743_aliened
alienee71013153_alienee
alieners889823_alieners
alienor7116303_alienor
align65016503_align__
aligns75312953_align_s
aline57243153_ali_ne_
alined75221403_ali_ned
aliners74717723_ali_ners
alines65735223_ali_nes
almner85710723_al_mner
almoner949383_almoner
assigner944853assigner
byliner1235723byli_ner
caliber1139733cali_ber
caliper11410963cali_per
clinger103812153_clinger
cosigner1135953cosigner
designer1036543designer
eloigner943423eloigner
fainer94717243fa_i_ner
falconer1346033falconer
feigner1135593_feigner
flinger113710513_flinger
gainer74117493ga_i_ner
imaginer1144303imagi_ner
liger65024473__lig_er
limner84112873__limner
liner55938923__li_ner
linger75226003__linger
magister1136283magister
magnet9320663ma__gnet
maigre9309163ma_igre_
mailer84724183ma_i_ler
maimer104514593ma_i_mer
mainliner1144673mainli_ner
malgre9299303mal_gre_
malice104818483mali_ce_
malices114316623mali_ces
malignant1245223malignant
maligning13145583maligning
malignity1543653malignity
malingered1442713malingered
malingerer1342173malingerer
malmier113611953mal_mier
maltier93015483mal_tier
maltster1035303maltster
manager103413583manag_er
manger94325003ma_ng_er
mangier104114063ma_ngier
mangler103215643ma_ngler
manlier92414023manli__er
manner84020513ma__nner
margined1237743margined
marine84230403mari_ne_
mariners103113863mari_ners
marines93928013mari_nes
marlier92614773marli__er
marline93320953marli_ne_
marlines103818713marli_nes
matier84321523mati__er
matinee92415613mati_nee
mauger93813483ma_ug_er
mazier175013063mazi__er
mealier93015903meali__er
milliner102811863milliner
miner76933543m__i_ner
misaligned1443583misaligned
moline84422033moli_ne_
motioner1037593motioner
obliger1035283oblig_er
palier85023563pali__er
plainer93811983plai_ner
realigned1145333realigned
resigner937793resigner
saline65132703sali_ne_
salines74029413sali_nes
signer74015633__signer
slinger83413833_slinger
unaligned1144873unaligned
vainer93714573va_i_ner
valine94623093vali_ne_
valines104520213vali_nes
veliger1137313velig_er

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.423422437.4
2DLD Change Limit1461621016.53022383.2
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.99925530.9
 
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.