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

44 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
bevomits154346(None) 
bevomit1445351bevomit_
bevomited1742772bevomited
vomits112610922__vomits
becomes132911963becom_es
becoming1538163becoming
becomings1643783becomings
bedouins1145513bedouins
bedsits1037563be_dsits
befits114711503be__fits
begonias1146263begonias
bemist105216953be__mist
bemists113410703be__mists
benefits1345713benefits
benomyls1542983benomyls
besmuts1134683be_smuts
besoms105712733besom__s
besots86415453beso__ts
betonies10413063betonies
bevies114017303bev__ies
bevomiting1843103bevomiting
bevors111610343bevo__rs
bromids12278603b_romids
bromins112513783b_romins
delimits1137573delimits
demits94918073de__mits
deposits1138843deposits
devoirs1175783devo_irs
emits75421473_e__mits
genomics1345713genomics
hermits12312143he_rmits
omits75018263___omits
permits11314003pe_rmits
readmits1136653readmits
recommits1544703recommits
reemits9611303re_emits
remits85622943re__mits
reposits10310453reposits
revisits1137423revisits
revolts1038893revo_lts
vomit102622573__vomit_
vomito11238033__vomito
vomitos12217103__vomitos
vomitus12215743__vomitus

Search took 9 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.1731032896.0
2DLD Change Limit146162448.79616616.9
3Display Results44440.0162750.0
 (SQL Overall)178691448.98519887.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.