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

86 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
miswrites144798(None) 
miswrite1348921miswrite_
miscites12313782mis_cites
misdrives1546212misdrives
miseries10320402miseri_es
misprices1547912misprices
misprizes2247222misprizes
misrates101318242mis_rates
miswrit1249412miswrit__
miswritten1552562miswritten
miswrote1346182miswrote_
cowrites133011593_cowrites
diorites9313523di_orites
disprizes2148113disprizes
disrates91118153dis_rates
disunites1088673disunites
kieserites1443643kieserites
masonites1149173masonites
mesquites20476433mesquites
midwifes17234713midw_ifes
midwives17274803midw_ives
migrates111112853mi_grates
millerites1247933millerites
mimetites1346823mimetites
minorities1249463minorities
miscite11314383mis_cite_
miscited13310423mis_cited
miscreates1448103miscreates
misdates111113633mis_dates
misdrive1446683misdrive_
misdriven1544073misdriven
misedited1346783misedited
misedits1147963misedit_s
misereres1148183misereres
misfaiths1742463misfaiths
misfiles133110983mis_files
misfires132210583mis_fires
misfits12279663mis_fit_s
misframes1646633misframes
misgives14329293mis_gives
misgrades1347363misgrades
misguides13165333misguides
mishits122513083mis_hit_s
mislies92922283mis_li_es
mislikes143311833mis_likes
mislives132912153mis_lives
mismates121114563mis_mates
mispoises1348353mispoises
misprice1448133misprice_
mispriced1646423mispriced
misprinted1545983misprinted
misprints13107223misprints
misprize2147543misprize_
misprized2346603misprized
misprizer2245343misprizer
misprizers2344013misprizers
misquotes2044593misquotes
misraises1149933misraises
misrate91319143mis_rate_
misrated111315383mis_rated
misroutes1148313misroutes
misrules1039383mis_rules
missies93423983mis_si_es
missiles103015083mis_siles
missises103513693mis_sises
missives133212843mis_sives
misstates11710633misstates
misstrikes1644363misstrikes
missuited1257023missuited
missuits1078023missuit_s
mistimes12612613mis_times
mistitles1147953mis_titles
mistraces13312293mistraces
mistrials1148133mistrials
mistruths1443683mistruths
miswriting1646843miswriting
nitrites82313453ni_trites
outwrites1238233outwrites
picrites121811083pi_crites
pisolites1149383pisolites
rewrites11311063_rewrites
siderites10410433siderites
skywrites1952763skywrites
sorites73825243__sorites
sprites94220333__sprites
writes94420333___writes

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 Limit148641866.95621368.7
3Display Results86860.0432000.0
 (SQL Overall)178691867.41924085.6
 
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.