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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
presummit155313(None) 
presummits1652341presummits
resubmit1243572_resubmit
preadmit1346813pre_admit
preaudit1177023preau_dit
prelimit1259123pre_limit
presplit1247753pres_plit
presume11310303presu_m_e
presumed1337973presu_med
presumer1247583presu_mer
presumers1336373presumers
presumes1239843presu_mes
presuming1437663presuming
pretermit1347133pretermit
recommit1445553_recommit
resubmits1342793_resubmits
resummon1242233_resummon
summit10311543___summit
crummie1336154cr__ummie
gremmie1264384gre__mmie
grummet12298874gr__ummet
jesuit1339584_jesu__it
permit10321684p_e__rmit
persimmon1552084persimmon
pessimist1345274p_essimist
plummet13278354p__lummet
preadmits1444924pre_admits
preatomic1546034preatomic
preaudits1265024preau_dits
prebudget1544074prebudget
prebuilt1247034prebu_ilt
precut102016534precu___t
preedit10512464pre__edit
preemie11310564pre__emie
preempt1337724pre__empt
preexempt2251904preexempt
preformat1646364preformat
prehuman1545034prehu_man
prehumans1643324prehumans
prelimits1366014pre_limits
premeet11615154pre__meet
premie103617994pre___mie
premix173710334pre___mix
premixt183510664pre__mixt
premolt11312074pre__molt
prenumber1543164prenumber
prepubis1443644prepu_bis
prescient13411324prescient
prescript1547034prescript
preselect1346984preselect
present94022734pres__ent
presentist12410094presentist
preset84430984pres___et
preship1439794pres__hip
president12410994president
presidia1147274pres_idia
presidio1146154pres_idio
presift12312224pres__ift
presort95219544pres__ort
pressman1247164pres_sman
pressmark1762844pressmark
pressmen1238834pres_smen
prest75736354pres____t
prestamp1445324prestam_p
prestamps1543524prestamps
presumable1645204presumable
presumably1953884presumably
presumedly1852544presumedly
presumption17154174presumption
presumptive2063064presumptive
presurvey1744604presurvey
preterit10315854pre_terit
pretermits1445044pretermits
preunite1039574pre_u_nite
previsit13410074pre_visit
prismoid1344984pris_moid
prosit85124594pros___it
prostomia1347524prostomia
psammite1442984p__sammite
pursuit948274pursu__it
readmit1039824_re_admit
recommits1544704_recommits
reemit8717224_re__emit
remit75737224_re___mit
reoutfit1184004_reoutfit
resit54241044_res___it
resmelt9411774_res_melt
resplit9310374_res_plit
result6318224_resu__lt
resume8313784_resu_m_e
resumed10310624_resu_med
resumer9410114_resu_mer
resumers1038084_resumers
resumes9313374_resu_mes
resuming11310084_resuming
resummons1342304_resummons
submit10312674___submit
summits1137984___summits

Search took 13 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 Filter1786911653290.440406115.9
2DLD Change Limit1653299812.00013777.4
3Display Results98980.0462130.4
 (SQL Overall)1786919812.48614311.3
 
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.