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

69 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
misallied124654(None) 
misallies1148381misallies
misapplied1742762misapplied
miscalled1447442miscall_ed
misrelied1247242misrelied
sallied83316952__sallied
allied74217153___allied
dallied93713613__dallied
dialled9510133di_all_ed
disabled1248713disabl_ed
disallowed1543263disallowed
gallied94115003__gallied
gillied95512313gi__llied
malled94626113m__all_ed
medalled1246893medall_ed
metalled1148983metall_ed
metallized2265583metallized
miauled1036663mi_aul_ed
milled94326173mi__ll_ed
millier93716703mi__llier
milliped1337383mi__lliped
misacted1338673misa_cted
misadded1335753misa_dded
misadvised1742633misadvised
misaimed1338093misa_imed
misalign1146433misa_lign
misaligned1443583misaligned
misallot1047003misall_ot
misallots1144533misallots
misallotted1451763misallotted
misally121111063misall__y
misallying1644313misallying
misalter1038343misa_lter
misaltered1344563misaltered
misapplies1643603misapplies
misatoned1246693misatoned
misbelief1645193misbelief
misbilled1445173misbilled
miscaller1346283miscall_er
miscalling1547863miscalling
miscarried1543823miscarried
misclaimed1744263misclaimed
miscopied1647163miscopied
misdialled1443013misdiall_ed
misfiled14278653misfil_ed
mislaid1039303mis_lai_d
misled94719313mis__l_ed
mislie83219153mis__lie_
mislies92922283mis__lies
misliked15319513mis_liked
mislived14328783mis_lived
misplaced1646253misplaced
misplayed1745303misplayed
mispled12310463mis_pl_ed
misrelies1149723misrelies
misruled1137083misrul_ed
misvalued1544283misvalued
muralled1136423murall_ed
rallied83514083__rallied
retallied1046783retallied
rivalled1236093rivall_ed
sallier73320423__sallier
sallies73227813__sallies
sullied83714483__sullied
tallied83314753__tallied
unallied938393_unallied
unsullied1044543unsullied
vialled1156843vi_all_ed
willied114611563wi__llied

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 Filter1786911486410.420425454.8
2DLD Change Limit148641697.08020994.5
3Display Results69690.0302300.0
 (SQL Overall)178691697.53023730.5
 
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.