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

85 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
misallies114838(None) 
misallied1246541misallied
misallots1144532misallots
misapplies1643602misapplies
mislies92922282mis__lies
misrelies1149722misrelies
sallies73227812__sallies
allies63827673___allies
ballies93725743__ballies
bialies93618413bi_a_lies
billies93923503bi__llies
cavallies1446393cavallies
challies133915643_challies
dallies84023193__dallies
dillies84122163di__llies
disables11410903disabl_es
disallows1343393disallows
fillies103420253fi__llies
gallies84122713__gallies
gillies84120963gi__llies
killies113318113ki__llies
mallees93315973m__allees
mealies92821933m_ea_lies
mesnalties1243923mesnalties
metallics1346133metallics
metallizes2156683metallizes
micelles1288833micell_es
miladies1139923mila_dies
milles84526563mi__ll_es
millier93716703mi__llier
milliers102611903mi__lliers
millimes122411373mi__llimes
millines102718063mi__llines
miracles1238333miracl_es
misadvices1842203misadvices
misadvise1542933misadvise
misadvises1642893misadvises
misaims11310113misa__ims
misalign1146433misa_lign
misaligns1244773misaligns
misalliances1652323misalliances
misallot1047003misall_ot
misally121111063misall__y
misallying1644313misallying
misalter1038343misa_lter
misalters1136913misalters
misandries1345063misandries
misapplied1742763misapplied
misatones1148933misatones
misbelief1645193misbelief
misbeliefs1742753misbeliefs
miscalled1447443miscall_ed
miscaller1346283miscall_er
miscallers1444303miscallers
miscalling1547863miscalling
miscalls1239003miscall__s
miscarries1445443miscarries
misclaims1544593misclaims
miscopies1549613miscopies
miseries10320403mis_eries
misfiles133110983misfil_es
mislie83219153mis__lie_
mislikes143311833mis_likes
mislives132912153mis_lives
misologies13139063misologies
misplaces1537953misplaces
misrelied1247243misrelied
misrules1039383misrul_es
missies93423983mis__sies
missiles103015083missil_es
missilries1244093missilries
misvalues1444683misvalues
mollies93420233m__ollies
rallies73823343__rallies
retallies939373retallies
rivalries1245003rivalries
sallied83316953__sallied
sallier73320423__sallier
salliers83613343__salliers
salties73725773__salties
sillies73425083__sillies
sullies74122233__sullies
tallies73624603__tallies
wallies103320743__wallies
willies103920153wi__llies

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.423422437.4
2DLD Change Limit148641857.03021143.8
3Display Results85850.0332575.8
 (SQL Overall)178691857.48623870.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.