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 “berming” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
berming12361483(None) 
beaming123618801beaming
beriming13310461beriming
perming123416091perming
terming104016001terming
arming94719802_arming
bamming144611812bamming
barbing123716992barbing
barding113822892barding
barfing134615092barfing
barging114018482barging
baring95135852bar_ing
barking144724182barking
barning104320352barning
barring104021592barring
beading113221862beading
beaning103820682beaning
bearding124011942bearding
bearing103624772bearing
beating104326872beating
becking164416072becking
becoming1538162becoming
becriming1646362becriming
bedding124114482bedding
beefing133911472beefing
beeping124013912beeping
begging123012652begging
begriming1545532begriming
being84920502be__ing
belling103825072belling
belting104119132belting
belying133612442belying
benaming1339692benaming
bending114420892bending
beraking153612972beraking
berating113220762berating
berhyming2042712berhyming
berlin83116372berlin_
berline93716852berline
berlins93216012berlins
berrying14137372berrying
berthing14209592berthing
besting104923922besting
betting103921402betting
beworming1734552beworming
birding114014922birding
birling104317052birling
birring103713062birring
blaming123515692blaming
bluming123511282bluming
booming123716222booming
boring94724872bor_ing
borking144716172borking
breaming133612512breaming
brewing133411152brewing
bring85528502b_r_ing
bumming143410782bumming
burking143716322burking
burling104421132burling
burning104215502burning
burping124012942burping
burring104016992burring
burying133413912burying
byrling13337372byrling
cering94522532cer_ing
deeming113913122deeming
ermine8416922_ermine
erring73816482_erring
farming133515082farming
firming132811222firming
forming133615732forming
gemming13289142gemming
germina1038492germina
gorming112810832gorming
harming133717932harming
helming133712002helming
hemming15269972hemming
herding122915122herding
herring113615882herring
jerking19308922jerking
kerbing14308482kerbing
kerfing15307532kerfing
kerning124010892kerning
lemming12269392lemming
merging112711762merging
nerving112910832nerving
perking143716462perking
reaming103924012reaming
rearming111413612rearming
seaming103222112seaming
seeming103216262seeming
serging93416672serging
sering74731812ser_ing
serving113014982serving
teaming103917592teaming
teeming103513092teeming
termini93410812termini
verging123812302verging
vermin113414522vermin_
versing112314192versing
warming133515082warming
worming132811242worming
yerking15368812yerking
zeroing1738342zeroing

Search took 5 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 Filter1786911076710.500357382.0
2DLD Change Limit1076711043.53330475.8
3Display Results1041040.0303466.7
 (SQL Overall)1786911044.06343980.1
 
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.