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 “mispainting” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

222 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
mispainting164529(None) 
mispointing1645791mispointing
misprinting1646821misprinting
impainting1544502_impainting
misparting1538082mispa_rting
misplanting1645632misplanting
bepainting15144883_bepainting
depainting14156153_depainting
discanting1449453disca_nting
disdaining1345993disdain_ing
disjointing2045293disjointing
disparting1438933dispa_rting
displanting1546043displanting
distaining1248903distain_ing
imprinting1546023_imprinting
misacting1439083mis_a_cting
misaiming1437873mis_ai_ming
misbinding1645063mis_binding
miscasting1557073misca_sting
misciting1439673mis_ci_ting
miscoining1597763miscoin_ing
miscounting1646053miscounting
misdating131010663misda__ting
miseating121215433misea__ting
misediting1446573misedi_ting
misfitting1645533mis_fitting
mishitting1645993mis_hitting
misjoining2085293misjoin_ing
mismating141211823misma__ting
misorienting15154963misorienting
mispaging1537803mispa__ging
mispaint121111893mispaint___
mispainted1545013mispaint_ed
mispaints13106183mispaint__s
misparsing1546613mispa_rsing
mispatching21133433mispatching
mispenning1545773misp_enning
misplanning1653873misplanning
mispoising1546583mispoi_sing
mispricing1746713mispri_cing
misprizing2447533mispri_zing
misraising1348123misrai_sing
misrating121014853misra__ting
missuiting1356743missui_ting
misthinking2143423misthinking
mistraining1446503mistrain_ing
miswriting1646843miswri_ting
outpainting1445153outpainting
painting113614423___painting
pinpointing1643103pinpointing
repainting13128973_repainting
sainting93215733__s_ainting
splinting1238193__splinting
sprinting12310033__sprinting
abstaining1344574abstain_ing
acquainting2352394acquainting
appointing1545324_appointing
attainting1144784_attainting
descanting1446924desca_nting
despairing1445064despai_ring
despiting13179324desp_i_ting
destaining1267944destain_ing
disappointing1952864disappointing
disbanding1545584disba_nding
discounting1547444discounting
disjoining1965724disjoin_ing
dismantling1543394disma_ntling
dismasting1446384disma_sting
dismounting1545084dismounting
disorienting14155654disorienting
disparaging1644724disparaging
dispatching20143524dispatching
dispending1547924disp_ending
dispensing1448234disp_ensing
dispiriting1545944dispiriting
disporting1439824disp_orting
dispraising1546044disprai_sing
disprizing2347924dispri_zing
disputing1337764disp__uting
disquieting2244304disquieting
disrating11714554disra__ting
dissenting121310294dis_senting
distancing1447084dista_ncing
distasting1248024dista_sting
distraining1346984distrain_ing
districting1559014districting
disuniting1247414disuni_ting
fainting123312164___fainting
impacting1635944_impa_cting
impairing1445474_impai_ring
imparting1437244_impa_rting
impasting1436324_impa_sting
impawning1743424_impawn_ing
impinging1544204_imp_inging
implanting1545324_implanting
imprintings1652764_imprintings
incanting1289904_inca_nting
inspanning1343204inspa_nning
islanding1135624_isla_nding
maintaining1453594maintain_ing
migrating13910534migra__ting
minting103020814m____inting
misadapting1743064misadapting
misadding14115834mis_a_dding
misaligning1543644misaligning
misallying1644314mis_allying
misapplying2152464misapplying
misatoning1346444mis_atoning
misbalancing1951684misbalancing
misbeginning1851684misbeginning
misbiasing1545204mis_biasing
misbiassing1642634misbiassing
misbilling1545544mis_billing
misbranding1744294misbranding
misbuilding1742734misbuilding
miscalling1547864misca_lling
miscarrying1942724miscarrying
misclaiming1844094misclai_ming
miscreating1648494miscreating
miscutting1576054mis_cutting
misdefining1843314misdefin_ing
misdialing1446264mis_dialing
misdialling1543304misdialling
misdoubting1742794misdoubting
misdriving1745164misdri_ving
misfiling1537224mis_fi_ling
misfiring1536974mis_fi_ring
misgauging1543904misga_uging
misgiving1645594mis_gi_ving
misgrafting1844084misgrafting
misguiding1544344misgui_ding
mishandling1843334mishandling
miskicking1844244mis_kicking
mislabeling1642794mislabeling
mislaboring1643034mislaboring
mislaying1557914misla__ying
mislearning1443724mislearn_ing
mislighting1843414mislighting
misliking1637114mis_li_king
misliving1546984mis_li_ving
mislocating1645894mislocating
mismaking18118024misma__king
mismanaging1743024mismanaging
mismarking1955864misma_rking
mismatching21123404mismatching
mismeeting1546244mis_meeting
misnaming1447424misna__ming
mispackaging2451344mispackaging
misphrasing1944154misphrasing
misplacing1745914misp_lacing
misplaying1845554misp_laying
mispleading1744354mispleading
mispoint121012364mispoint___
mispointed1545574mispoint_ed
mispoints13106634mispoint__s
misprint12912974misprint___
misprinted1545984misprint_ed
misprints13107224misprint__s
misquoting2244364mis_quoting
misrelating1447274misrelating
misrouting1347224mis_routing
missaying1537634missa__ying
misseating131310944mis_seating
missending1446494mis_sending
missetting13107904mis_setting
missioning1347404mis_sioning
missorting1347124mis_sorting
missounding1543444missounding
misspacing1784984misspa__cing
misspending1743654misspending
misstarting14125204misstarting
misstating13129314mis_stating
mistaking1699694mista__king
mistending1447954mis_tending
mistiming1438914mis_ti_ming
misting103623384mis____ting
mistitling1346224mis_titling
mistreating1449284mistreating
mistrusting1465924mistrusting
mistrysting1774314mistrysting
mistuning1237674mis_tun_ing
misvaluing1684604misva_luing
mordanting1444004morda_nting
mosaicking1942964mos_aicking
offprinting2052114offprinting
outpointing1445104outpointing
outsprinting1553034outsprinting
paining103920244___pain_ing
paintings12327104___paintings
panting104025424___pa_nting
pointing112813684___pointing
preprinting1647414preprinting
printing113216084___printing
reprinting131510584_reprinting
respiting121912864resp_i_ting
resplitting1444944resplitting
respringing1544584respringing
saining83621394__s_ain_ing
sandpainting1662084sandpainting
scanting113914764__sca_nting
slanting94115094__sla_nting
spanking153911974__spa_nking
spanning113311084__spa_nning
spatting113111764__spa_tting
spawning14296914__spawn_ing
spinning113310814__sp_inning
spirting112913634__sp_irting
spiting103917624__sp_i_ting
spitting113012324__sp_itting
splining11310774__splin_ing
splitting1236564__splitting
spraining1248154__sprain_ing
springing1338744__springing
squinting1936224__squinting
staining9413374__stain_ing
stinting93415744__s_tinting
surprinting1444554surprinting
sustaining1145884sustain_ing
tainting93613584___tainting
unstinting1147304uns_tinting
upspringing1752094upspringing
visiting1238394vis__i_ting

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 Filter1786911488190.406440125.6
2DLD Change Limit1488192228.12318320.7
3Display Results2222220.1261761.9
 (SQL Overall)1786912228.65520646.0
 
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.