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

149 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
mispatching2113343(None) 
dispatching20143521dispatching
mismatching21123401mismatching
despatching20122652despatching
matching163512393m___atching
misacting1439083mis_a_cting
misatoning1346443mis_atoning
misdating131010663misdat__ing
miseating121215433miseat__ing
mismating141211823mismat__ing
mispaging1537803mispa__ging
mispainting1645293mispainting
misparsing1546613mispa_rsing
misparting1538083mispa_rting
mispatch1743853mispatch___
mispatched2053833mispatch_ed
mispatches1974103mispatch_es
misplacing1745913misplac_ing
mispricing1746713mispric_ing
misrating121014853misrat__ing
misspacing1784983misspa_c_ing
misteaching1944533misteaching
mistouching1942993mistouching
patching163212753___patching
repatching1844993_repatching
snatching1536363__snatching
batching163712094___batching
birdwatching245764birdwatching
bitching163610624bi___tching
catching163712774___catching
dethatching2142244dethatching
disbranching2152484disbranching
disparaging1644724disparaging
disparting1438934dispa_rting
dispatch1654554dispatch___
dispatched1993884dispatch_ed
dispatcher1853264dispatch_er
dispatchers1972464dispatchers
dispatches1874584dispatch_es
displacing1646414displac_ing
disputing1337764disput__ing
disrating11714554disrat__ing
distancing1447084distanc_ing
ditching15349944di___tching
enswathing1742684enswat_hing
hatching173312214___hatching
hitching173310524hi___tching
impacting1635944_impa_cting
impeaching2043374_impeaching
inarching1546344_i_narching
inswathing1742974inswat_hing
itching134011684_i___tching
latching143712024___latching
marching164312194m___arching
massacring1543594massa_cring
miching152911804mi____ching
migrating13910534migrat__ing
misadding14115834mis_a_dding
misaiming1437874mis_a_iming
misallying1644314mis_allying
misaltering1445124misaltering
misapplying2152464misapplying
miscalling1547864misca_lling
miscarrying1942724miscarrying
miscasting1557074misca_sting
misciting1439674miscit__ing
miscuing1338734mis___cuing
miscutting1576054miscut_ting
misentering1446384misentering
misfitting1645534misfit_ting
misgauging1543904misga_uging
mishandling1843334mishandling
mishitting1645994mishit_ting
miskicking1844244mis_kicking
mislabeling1642794mislabeling
mislaboring1643034mislaboring
mislaying1557914misla__ying
mismaking18118024misma__king
mismanaging1743024mismanaging
mismarking1955864misma_rking
mismatch1743944mismatch___
mismatched2063404mismatch_ed
mismatches1953754mismatch_es
misnaming1447424misna__ming
mispackaging2451344mispackaging
mispaint121111894mispa___int
mispenning1545774misp_enning
misphrasing1944154misphrasing
misplanning1653874misplanning
misplanting1645634misplanting
misplaying1845554misp_laying
mispleading1744354mispleading
mispointing1645794mispointing
mispoising1546584misp_oising
misprinting1646824misprinting
misprizing2447534misp_rizing
misraising1348124misra_ising
missaying1537634missa__ying
misseating131310944misseat__ing
missetting13107904misset_ting
misstamping1842994misstamping
misstarting14125204misstarting
misstating13129314mis_stating
misstyling1643834mis_styling
mistaking1699694mis__taking
misthink1745434mis__t_hink
mistiming1438914mis__timing
misting103623384mis__t__ing
mistitling1346224mistit_ling
mistracing1569604mistrac_ing
mistuning1237674mis__tuning
mistutoring1442824mistutoring
mistyping1744724mis__typing
misvaluing1684604misva_luing
mosaicking1942964mos_aicking
outcatching1943114outcatching
outmatching1943334outmatching
outpitching1962974outpitching
outwatching2043014outwatching
parching164313054___parching
pitching163411114___pitching
potlatching1952114potlatching
rematching1844914_rematching
researching1743424researching
resketching2142274resketching
respacing1438894respa_c_ing
restitching1744004restitching
scathing14269704__scat_hing
scotching1735654__scotching
scratching1844534_scratching
scutching1735224__scutching
searching1538344__searching
sketching1935084__sketching
smutching1734854__smutching
snitching1535914__snitching
spacing123614494__spa_c_ing
spatting113111764__spat_ting
splotching1842864__splotching
stanching1538084__stanching
starching1538594__starching
stitching1547104__stitching
swathing15248714__swat_hing
switching1835704__switching
thatching1835144__thatching
unlatching1643154_unlatching
unstitching1742644unstitching
unswathing1743304unswat_hing
watching173011174___watching
witching173410634wi___tching

Search took 10 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.453394461.4
2DLD Change Limit1488191498.86016796.7
3Display Results1491490.0761960.5
 (SQL Overall)1786911499.38919032.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.