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

92 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
miswrit124941(None) 
miswrite1348921miswrite
misedit10311042misedit
misfit112813832mis_fit
mishit112618202mis_hit
mislit83019692mis_lit
misprint12912972misprint
missuit9911302missuit
miswrites1447982miswrites
miswrote1346182miswrote
biscuit1147373biscuit
dimwit1237953dimw_it
disherit12412523disherit
dispirit1149203dispirit
distrait9414343distrait
district11413873district
eiswein1043503eiswein
esprit8312843_esprit
merit7339183m__erit
mesquit18387953mesquit
midrib1138243mi_drib
minaret9520683minaret
minority1347933minority
miri66730383mi__ri_
mirin75023153mi__rin
misact10316693mis_act
misaim10311853mis_aim
misbuilt1245093misbuilt
miscast11312423miscast
miscite11314383mis_cite
miscoin11311433miscoin
miscut10614823mis_cut
misdid10510573mis_did
misdraw1345623misdraw
misdrew1335833misdrew
misdrive1446683misdrive
miseat82925713mis_eat
misedits1147963misedits
miser75430403miser__
miseries10320403miseries
miserly12329823miserly
misers85025703miser_s
misery114113543miser_y
misfaith1644543misfaith
misfire12229893misfire
misfits12279663mis_fits
misgraft1447203misgraft
misgrew1335523misgrew
misgrow1344433misgrow
mishits122513083mis_hits
misjoin1637693misjoin
miskept1538923miskept
mislaid1039303mislaid
mislain9311243mislain
mislie83219153mis_lie
mismeet113215163mismeet
mismet103722373mis_met
misorient11510893misorient
mispaint121111893mispaint
mispart111113783mispart
mispoint121012363mispoint
misprice1448133misprice
misprints13107223misprints
misprize2147543misprize
misrate91319143mis_rate
missaid10310303missaid
misseat93617243misseat
missent94318713missent
misset85028153mis_set
missis84417503mis_sis
missort9314653missort
missout9412663missout
missuits1078023missuits
mist66154543mis___t
mistrain10311943mistrain
mistral91013643mistral
mistreat10313113mistreat
mistrial10311383mistrial
mistrust1049203mistrust
mistruth1346043mistruth
mistryst1345843mistryst
misword1338413misword
miswords1446603miswords
miswriting1646843miswriting
miswritten1552563miswritten
muskit122813253mus_kit
muskrat1346733muskrat
nitwit938593nitw_it
outwrit10411423outwrit
sprit76736403__sprit
visit8320963vis__it
writ75537913___writ

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 Filter1786911340270.843211970.3
2DLD Change Limit134027926.50020619.5
3Display Results92920.0303066.7
 (SQL Overall)178691927.37324235.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.