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

80 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
misstart1041004(None) 
misstarts1145831misstarts
mispart111113782mi_spart
misseat93617242missea_t
missort9314652miss_ort
misstamp1443802misstamp
misstarted1344872misstarted
misstate10711342misstate
bistort91216523bi_stort
dispart101115283di_spart
disseat83816923dissea_t
dissert83720693diss_ert
distant83519953di_stant
distort81120333di_stort
emissary1343473emiss_ary
instant7815353_instant
instar6310013_instar_
instars7411133_instars
issuant748263_issuant
kickstart1453833kickstart
midstory1445103midstory
militant10411403militant
military1347233military
minster93914323minster_
minsters103813923minsters
misact10316693mi_s_act
misadapt1345203misadapt
misaward1464593misaward
miscast11312423mi_scast
misdealt1147983misdealt
miseat82925713mi_sea_t
misgraft1447203misgraft
mishear1238393mishear_
misheard1446253misheard
mishears1338323mishears
mislearn1045343mislearn
mislearnt1195553mislearnt
mismark1536703mi_smark
misparts12108173mi_sparts
misplant12410763misplant
missaid10310303miss_aid
missal84314903miss_a_l
missals93914433miss_als
missay114112143miss_a_y
missays124010253miss_ays
misseats104011683misseats
missent94318713miss_ent
misset85028153miss__et
misshape1545983misshape
missilry1344653missilry
missorts1038323miss_orts
missout9412663miss_out
misspace1446523misspace
misspelt1247273misspelt
misspent1259173misspent
misstamps1543373misstamps
misstarting14125203misstarting
misstated1278973misstated
misstates11710633misstates
missteer1037223missteer
missteers1135913missteers
misstep11158463misst_ep
missteps12156143missteps
misstop11156413misst_op
misstops12176413misstops
misstyle1345273misstyle
missuit9911303miss_uit
mistake131312623mi_stake
mister84728563mi_ster_
misterm114314513mi_sterm
misters93927513mi_sters
mistral91013643mi_stral
mustard10359533m_ustard
outstart81611283outstart
pissant91012503piss_ant
redstart949193redstart
restart7320033_restart
start55642313___start
upstart9159753_upstart
visitant1147363visitant

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 Filter1786911461620.423422437.4
2DLD Change Limit146162807.26620115.9
3Display Results80800.0302666.7
 (SQL Overall)178691807.71923149.5
 
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.