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

117 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
misruling123749(None) 
miauling1137342mi_auling
miscuing1338732miscu_ing
misfiling1537222misfiling
misrating121014842misrating
misrelying1645502misrelying
misrouting1347222misrouting
mistuning1237672mistuning
misusing1138892mis_using
birling104317053bi_r_ling
circling1338423ci_rcling
dirling93316073di_r_ling
disabling1337753disabling
disputing1337763disputing
disrating11714553disrating
disrobing1347703disrobing
disrupting1446343disrupting
disusing1039003dis_using
ensouling1046003ensouling
ferruling13134403ferruling
feruling1258873_feruling
firstling1334423firstling
fissuring1344813fissuring
girdling1146823gi_rdling
hireling121210993hi_reling
hirpling1467223hi_rpling
hirseling1396273hirseling
hirsling1277543hi_rsling
imbruing1343993imbru_ing
imbruting1443773imbruting
insouling1036823insouling
isling71213873_is__ling
issuing836053_issu_ing
maculing13219583m_aculing
marbling13179883m_arbling
marling103322763m_ar_ling
masculine1346443masculine
mauling103315683m__auling
miaouing1134893miaou_ing
middling13249333mi_ddling
migrating13910523migrating
milling103223683mi__lling
mingling122010933mi_ngling
minuting1139723mi_nuting
miring93723793mi_r__ing
mirroring1246183mirroring
misacting1439083misacting
misadding14115833misadding
misaiming1437873misaiming
misalign1146433mis_align
misallying1644313misallying
misbilling1545543misbilling
misbuilding1742733misbuilding
miscalling1547863miscalling
misciting1439673misciting
miscoding1538183miscoding
miscutting1576053miscutting
misdating131010663misdating
misdealing1457363misdealing
misdialing1446263misdialing
misdoing1238803mis_doing
misdrawing1745803misdrawing
misdriving1745163misdriving
miseating121215433miseating
misfiring1536973misfiring
misframing1846233misframing
misgauging1543903misgauging
misgiving1645593misgiving
misgrading1546823misgrading
misgrowing1744633misgrowing
misguiding1544343misguiding
misjudging2242783misjudging
mislaying1557913mislaying
misliking1637113misliking
misliving1546983misliving
mislying1437843mis_lying
mismaking18118013mismaking
mismating141211813mismating
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
mispricing1746713mispricing
misprizing2447533misprizing
misquoting2244363misquoting
misraising1348123misraising
misreading1448253misreading
misrelating1447263misrelating
misrelied1247243misrelied
misrelies1149723misrelies
misrule939353misrul__e
misruled1137083misrul_ed
misrules1039383misrul_es
missaying1537633missaying
missing103619073mis__sing
misstyling1643833misstyling
missuiting1356743missuiting
mistaking1699683mistaking
mistiming1438913mistiming
misting103623383mis__ting
mistitling1346223mistitling
mistracing1569603mistracing
mistrusting1465913mistrusting
mistyping1744723mistyping
misvaluing1684603misvaluing
miswriting1646843miswriting
misyoking1944913misyoking
mitring103514143mitr__ing
mizzling19255443mi_zzling
morseling1238073morseling
muling93519883m___uling
muscling1337853mus_cling
nonruling1046433nonruling
pistoling1268493pistoling
ruling73219553___ruling
siruping1136503si_ruping
tirling83315733ti_r_ling
tissuing935103tissu_ing

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.1731032896.0
2DLD Change Limit1486411177.18620684.8
3Display Results1171170.0502340.0
 (SQL Overall)1786911177.40924118.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.