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

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

109 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
brevity153480(None) 
brevet115717342brevet_
brevetcy1841732brevetcy
brevets12519412brevets
breviary1642632breviary
brevier1237772brevier
gravity1437182gravity
levity1277902_levity
privity15268322privity
amenity1238333amenity
arenite71017723arenite
aridity11510113aridity
barefit1249733barefit_
beauty115410163b_eauty
bedirty1344183b_edirty
beefily1535613beefily
befit105222663b_efit_
befits114711513b_efits
beigy111110583b_e_igy
bevies114017313b_evies
bevy127115223b_ev__y
bheesty1542493bheesty
biggity1435013biggity
brainy114815643br_ainy
bratty1159683br_atty
bravely15428233bravely
bravery15428133bravery
bravi104715753bravi__
braving133714613braving
breadth1365993breadth
bready124511183bre_ady
breast8319643breast_
breasts939713breasts
breath113916273bre_ath
breathy15328043breathy
breezily2243653breezily
breezy20295853bre_ezy
brent75734133bre_nt_
brents84717283bre_nts
breve105317053brev__e
breves115516433brev_es
breveted1435633breveted
breviers1335943breviers
brevities1446443brevities
brewery15376963brewery
brewing133411153brewing
brewis11469993brewi_s
briny104719663br__iny
brit66350153br__it_
brith104924373br__ith
brits76433093br__its
britt75732233br__itt
bruit76126723br_uit_
bruits85714463br_uits
brutify1543883brutify
cavity14310013_cavity
cecity1398153_cecity
credit9315193credit_
credits1039983credits
crevice1436153crevice
crudity1336043crudity
deity94316773_de_ity
eremite9312833eremite
evite85317683__evite
ferity122813343_ferity
fretty1249223fre_tty
fruity12429703fr_uity
heredity1546493heredity
lenity9612713_lenity
nervily1336863nervily
obesity1275653obesity
orality101111683orality
pretty11510873pre_tty
preview1536473preview
previse123713803previse
privily15207623privily
probity14299683probity
rarity93615493_rarity
reality10313573_reality
realty92713693_realty
recit75235103_recit_
recite83625113_recite
recits83621363_recits
refit84230063_refit_
refits94017663_refits
reify114814973_re_ify
relit55340683_relit_
remit75737223_remit_
remits85622953_remits
resiny94617363_resiny
resit54241043_resit_
resite64128453_resite
resits64725573_resits
revery124014213_revery
revet84938843_revet_
revets94022183_revets
review1238693_review
revile94921613_revile
revise94019753_revise
revive124914823_revive
revote94917453_revote
serenity1168963serenity
suavity1336323suavity
treaty94414353tre_aty
trevet94818913trevet_
trevets10499983trevets
trinity10310843trinity
verity123714853_verity
weevily1694643weevily

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 Filter1786911340270.470380193.6
2DLD Change Limit1340271097.73617325.1
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.25221654.3
 
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.