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

73 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
berseems126393(None) 
berseem1166461berseem_
beseems1175911be_seems
berserks1433992berserks
beseem1069082be_seem_
burseeds1134782burseeds
meseems1165602me_seems
bargees105415873bargee_s
barkeeps1634143barkeeps
bedsheets1542943bedsheets
beebees1138013beebee_s
belleeks1444363belleeks
bendees103913863bendee_s
berakes134815773berake_s
berates94126873berate_s
berberis1246603berberis
berets85822523ber__ets
bergeres1189113bergeres
berhymes1843803berhymes
berimes115216643berime_s
bermes106023003ber_me_s
berms95323663ber___ms
berries94423553berrie_s
berserk1334913bers_erk
berserkers1642943berserkers
beseech1453873be_seech
beseemed1334853be_seemed
beses75830723be_s_e_s
besets85718803be_s_ets
besoms105712733be_s_oms
beweeps1494563be_weeps
birdseeds1342243birdseeds
biremes1138773bir_emes
birses84717733birs_e_s
boreens9310403bor_eens
breams104815043b_r_eams
breeds94914883b_r_eeds
breeks125310793b_r_eeks
brees75632553b_r_ee_s
bugseeds1242843bugseeds
burgees104915893burgee_s
burseed1049503bursee_d
burses84425513burs_e_s
bursters1038983bursters
burweeds1434103burweeds
erses55826803_ers_e_s
esteems935243_esteems
hareems12428203har_eems
jereeds15326393jer_eeds
jerreeds1653273jerreeds
jerseys1733243jers_eys
kerseys1433993kers_eys
lessees73510243lessee_s
mergees104411233mergee_s
meristems1343553meristems
oersteds934373oersteds
overseeds13248893overseeds
overseers12298783overseers
oversees112415903oversee_s
pensees9311203pensee_s
perses85428063pers_e_s
redeems1037163re_deems
reseeds84012333re_seeds
reseeks11348623re_seeks
resees63827483re_see_s
seems75525023___seems
terreens8246533terreens
terseness948403terseness
versemen1346853versemen
versers103813523vers_ers
verses94223763vers_e_s
versets103913103vers_ets
verstes104014283verste_s

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.436409841.7
2DLD Change Limit146162736.67321903.5
3Display Results73730.0302433.3
 (SQL Overall)178691737.13925030.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.