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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
betta7491684(None) 
beta66234131be_ta
bettas84913921bettas
abettal946072abettal
batt65053872batt_
batts76727562batts
battu75216612battu
batty105422242batty
beat66168302beat_
beats76042252beats
beet66457542beet_
beets76131442beets
begat86629722begat
belga8313232belga
belt65754032belt_
belts75931162belts
bema85825252be_ma
bemata10411692bemata
bent67759912bent_
bento75922952bento
bents76033692bents
beretta938462beretta
berth104917882berth
bertha11429172bertha
best66355322best_
bests75932612bests
bet58376672be_t_
betas75528762betas
betel74419902betel
beth96629232be_th
beths105519222beths
beton76022062beton
betray111511442betray
bets67051442be_ts
betted94721162betted
better84723702better
bettor83612222bettor
biota74516822biota
biretta947242biretta
bitt65545822bitt_
bitts75022592bitts
bitty106119172bitty
bota66236502b_ota
bott66548572bott_
botts75224862botts
butt65143742butt_
butte74924292butte
butts75824252butts
butty104020112butty
cesta75419482cesta
cotta75818572cotta
delta66117772delta
eta35834192_e_ta
etna46415262_etna
feta76528902fe_ta
geta56627442ge_ta
gutta64613382gutta
jetty156212582jetty
lepta75714392lepta
lytta888062lytta
menta74424422menta
meta65932412me_ta
nett46643232nett_
netts55320722netts
netty85816762netty
petti75119452petti
petto76021042petto
petty105320292petty
pitta75018692pitta
reata54225392reata
recta74220262recta
retia55326112retia
septa75518082septa
seta45637312se_ta
sett45949052sett_
setts55124322setts
sutta54015332sutta
tecta74215522tecta
testa54822042testa
tetra53417952tetra
vesta86618302vesta
vitta85015172vitta
yenta83917042yenta
yett76434492yett_
yetts86715132yetts
zeta135121642ze_ta

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800861.42337807.4
3Display Results86860.0302866.7
 (SQL Overall)178691861.766101184.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.