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

82 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
misprints1310722(None) 
mispaints13106181mispaints
mispoints13106631mispoints
misprint12912971misprint_
imprints1247302_imprints
midpoints14103802midpoints
misorients1256002misorients
mispaint121111892mispaint_
misplants1347312misplants
mispoint121012362mispoint_
misprices1547912misprices
misprinted1545982misprinted
misprizes2247222misprizes
sprints94113772__sprints
disjoints1745473disjoints
disorients1177793disorients
dispirits1246153dispirits
displants1248073displants
disprizes2148113disprizes
distraints1166883distraints
districts1248943districts
esprits938393_espri_ts
impaints1236243_impaints
imprint11312563_imprint_
mainsprings1672403mainsprings
midpoint13117493midpoint_
migrants1138183mi_grants
mirins83918903mi__rin_s
misagents1246793misagents
misbinds1345163mis_binds
misbrands1445153misbrands
miscoins12311083miscoin_s
miscounts1386413miscounts
miscreants1445083miscreants
misdoings1344423misdoings
misdrives1546213misdrives
misedits1147963misedi_ts
miseries10320403miseri_es
misevents1456003misevents
misfits12279663mis_fi_ts
misgrafts1544293misgrafts
mishits122513083mis_hi_ts
misjoins1736913misjoin_s
misorient11510893misorient_
mispainted1545013mispainted
misparts12108173misp_arts
mispens11311073misp_en_s
misplans1238863misplan_s
misplant12410763misplant_
mispointed1545573mispointed
mispoises1348353mispoises
misprice1448133mispri_ce
mispriced1646423mispriced
misprinting1646823misprinting
misprize2147543mispri_ze
misprized2346603misprized
misprizer2245343misprizer
misprizers2344013misprizers
missuits1078023missui_ts
misthinks1843353misthinks
mistrains11511353mistrain_s
mistreats1148633mistreats
mistrials1148143mistrials
mistrusts1146013mistrusts
mistrysts1443863mistrysts
miswrit1249413miswri_t_
miswrite1348923miswri_te
miswrites1447983miswrites
newsprints1552753newsprints
offprints1742443offprints
outsprints1243573outsprints
pinpoints1344153pinpoints
preprints1347473preprints
prints84320103___prints
reprints1039903_reprints
resprings12156253resprings
splints94511743__splints
springs104415923__springs
sprint84526793__sprint_
sprits85122533__spri_ts
surprints1145283surprints
upsprings1442703upsprings

Search took 9 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.440406115.9
2DLD Change Limit148641827.78019105.5
3Display Results82820.0461782.6
 (SQL Overall)178691828.26621617.6
 
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.