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

110 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
mispaint12111189(None) 
mispaints13106181mispaints
mispoint121012361mispoint
misprint12912971misprint
impaint11511222_impaint
midpoint13117492midpoint
mislain9311242mislain_
mispaging1537802mispaging
mispainted1545012mispainted
mispart111113772mispa_rt
misplant12410752misplant
mispoints13106632mispoints
misprints13107222misprints
bepaint11312183_bepaint
depaint10314593_depaint
discant103017253disca_nt
disdain938513disdain_
disdains1037913disdains
disjoint1649233disjoint
dispart101115283dispa_rt
displant11412223displant
distain8313783distain_
distains9413603distains
distant83519953dista_nt
distraint101112903distraint
impaints1236243_impaints
imprint11312563_imprint
lisping103412753lisp_ing
midpoints14103803midpoints
migraine1157863migraine
migrant10314313migra_nt
misact10316683mis_a_ct
misagent11410723misagent
misaim10311853mis_ai_m
misaims11310113mis_aims
misbind1258273mis_bind
misbuilt1245093misbuilt
miscast11312413misca_st
miscoin11311433miscoin_
miscoins12311083miscoins
miscount1299463miscount
miscuing1338733miscuing
misdating131010663misdating
misdoing1238803misdoing
miseat82925703misea__t
miseating121215433miseating
misedit10311043misedi_t
misevent1349223misevent
misfaith1644543misfaith
misfit112813833mis_fi_t
mishit112618193mis_hi_t
misjoin1637693misjoin_
misjoins1736913misjoins
mislaid1039303mislai_d
mislaying1557913mislaying
mislearnt1195553mislearnt
mislit83019693mis_li_t
mislying1437843mislying
mismaking18118023mismaking
mismating141211823mismating
misnaming1447423misnaming
misorient11510893misorient
mispage12310523mispa_ge
mispaged1438243mispaged
mispages13311183mispages
mispainting1645293mispainting
misparse1237733misparse
misparsing1546613misparsing
misparting1538083misparting
misparts12108173misparts
mispatch1743853mispatch
mispen10312173misp_en_
mispens11311073misp_ens
misplacing1745913misplacing
misplan1147773misplan_
misplans1238863misplans
misplants1347313misplants
misplaying1845553misplaying
mispointed1545573mispointed
mispoise1248263mispoise
misprice1448133misprice
misprinted1545983misprinted
misprize2147543misprize
misraise10410523misraise
misrating121014853misrating
missaid10310303missai_d
missaying1537633missaying
missent94318713mis_sent
missing103619073mis_sing
misspacing1784983misspacing
misspent1259173misspent
missuit9911303missui_t
mistaking1699693mistaking
misthink1745433misthink
misting103623383mis_ting
mistrain10311943mistrain_
mistrains11511353mistrains
misusing1138893misusing
miswrit1249413miswri_t
outpaint10311773outpaint
paint75443693___paint
pinpoint1248993pinpoint
pissant91012503pissa_nt
repaint9318363_repaint
saint55147073__s_aint
spait75631603__spai_t
splint85223283__splint
sprint84526793__sprint
visaing11279333vis_aing
wisping133711943wisp_ing

Search took 7 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621106.28323263.1
3Display Results1101100.0462391.3
 (SQL Overall)1786911106.74926476.7
 
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.