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

89 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
overasserts145355(None) 
overassert1346501overassert_
overasserted1673462overasserted
overalert12411113overa_lert_
overasserting1754143overasserting
overassertion16113513overassertion
overassertions17133303overassertions
overassertive1982513overassertive
overexerts2044743over_exerts
overmasters1644823overmaster_s
overpasses1546593overpasse__s
overseers12298783over_seer_s
oversets113114173over__se_ts
overshirts1644783over_shirts
overskirts1743713over_skirts
reasserts945983_re_asserts
asserts74311794____asserts
brassarts1143824__brassarts
degassers11354834_degasser_s
desserts9247924_de__sserts
erasers74413944__era_ser_s
harassers1246204_harasser_s
oleasters936734ole_aster_s
operagoers1342764operagoer_s
overacts1339654overa___cts
overadvertise2062724overadvertise
overages12513834overa_ge__s
overarms13258384overa___rms
overawes14511184overa_we__s
overbeats14279824over__beats
overbets132510684over__be_ts
overcasts14217854overcas__ts
overclasses1644894overclasse__s
overcomers17125784overcomer_s
overdirects1752814overdirects
overdoers13117404over_doer_s
overdoses13119794overdose__s
overdyers16125004over_dyer_s
overeaters1348634overeater_s
overeats112415264over___eats
overexert1947844over_exert_
overgarments18133674overgarments
overgoverns1852254overgoverns
overharvests2151634overharvests
overheats15229994over__heats
overissues1343744overiss_ues
overlets112312364over__le_ts
overmaster1546024overmaster__
overmastered1862744overmastered
overmelts1447264over__melts
overpassed1645954overpasse__d
overpayments2253494overpayments
overpert13312994over__pert_
overpowers1844724overpower_s
overreports1652994overreports
oversales12313144oversale__s
oversalts1238164over__salts
oversaves15310184oversave__s
overscores1547364over_scores
overseas112612424over__se_as
overseeds13248894over__seeds
overseer112611074over_seer__
oversees112415904over__se_es
oversells1236974over__sells
overset102821474over__se_t_
oversews14289424over__se_ws
overshirt1547904over_shirt_
overshoots1644394over_shoots
overshots1546624over__shots
oversights1744444over_sights
overskirt1646214over_skirt_
oversleeps1553254over_sleeps
overslept1446854over_slept_
overspends1644444over_spends
overspent1449924over_spent_
oversteers1344864over_steers
oversteps1436304over_ste_ps
overstirs1238214over_stir_s
overstress1345764over_stress
overstrews1644474over_strews
oversweet1548904over_sweet_
overtreats1346644over_treats
overuses11312644over_use__s
overwaters1645754overwater_s
overwets14219954over__we_ts
reassert8313674_re_assert_
reassorts945624_re_assorts
versers103813524_ver__ser_s
versets103913104_ver__se_ts

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.436409841.7
2DLD Change Limit148819899.06316420.5
3Display Results89890.0461934.8
 (SQL Overall)178691899.54518720.9
 
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.