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

56 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
berhymed194331(None) 
berhyme1743811berhyme_
berhymes1843801berhymes
berimed124912282ber_imed
bermed115217722ber__med
beshamed1635732beshamed
rhymed15416712__rhymed
unrhymed1742852unrhymed
beamed115720733be__amed
becalmed1534813becalmed
bechamel1754283bechamel
becharmed1944663becharmed
becrimed1565513becrimed
bedimmed1643443bedimmed
bedroomed1543643bedroomed
begrimed1475213begrimed
begrimmed1742543begrimmed
behaved16176683be_haved
behoved16205563be_hoved
belayed133610083belay_ed
benamed122911093be_named
beraked144312433ber_aked
berated104422133ber_ated
bereaved1446403bereaved
berhyming2042713berhyming
berime105317333ber_ime_
berimes115216643ber_imes
beringed1298173beringed
berme96022943ber__me_
bermes106023003ber__mes
berobed1238233ber_obed
berouged1235323berouged
berried103714043ber_ried
berthed13259123ber_thed
beseemed1334863beseemed
beshame1447483beshame_
beshames1537203beshames
beslimed1335013beslimed
bethumped1941493bethumped
betrayed1436303betray_ed
bewormed16235443bewormed
bewrayed1733933bewray_ed
brayed124615783b_ray_ed
breamed124011593b_reamed
brimmed14386783b_rimmed
broomed124111053b_roomed
exhumed2043413_exhumed
ferrymen1643943ferrymen
misrhymed2042743misrhymed
overhyped2144153overhyped
perfumed1654543perfumed
permed115217353per__med
rhyme13479553__rhyme_
rhymer14387083__rhymer
rhymes14419823__rhymes
termed94816703ter__med

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 Limit146162566.78321548.3
3Display Results56560.0301866.7
 (SQL Overall)178691567.24924650.4
 
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.