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

91 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
arbelest104950(None) 
arbalest1039521arbalest
arbelests1143651arbelests
abeles84719392a_beles_
ablest84721832a_b_lest
arbalests1144122arbalests
arbalist10313332arbalist
cruelest1059182cruelest
abele76323253a_bele__
ableist9311773a_bleist
ables75935543a_b_les_
abreast9311273abre_ast
ageless8310343a_geless
alleles73812033alleles_
ambles105121863amb_les_
amplest11312333a_mplest
aneles64626293a_neles_
arables91814973arables_
arbalists1148483arbalists
arbores94016033arbores_
arborist10411613arborist
arbutes939703arbutes_
arenes64928393ar_enes_
areoles71016953areoles_
aretes64425353ar_etes_
argles75218483ar_gles_
argyles1136053argyles_
aridest8316143ar_idest
ariels65119373ariel_s_
arles56735743ar__les_
armless9369943ar_mless
armlet84118193ar_mle_t
armlets94610063ar_mlets
armrest9310163ar_mrest
arrest63722633ar__rest
artels66216233artel_s_
artiest73121993ar_tiest
artless73712513ar_tless
artsiest879653artsiest
aweless1038723a_weless
barbells12368823barbells_
barbels114514433barbel_s_
barbless12318713barb_less
barbules1238043barbules_
barrenest1149563barrenest
behest11314613__behest
blest76431723__b_lest
briefest1335893briefest
careless102813633car_eless
cruellest1155583cruellest
darnedest1145253darnedest
drollest937353drollest
feeblest1336913feeblest
frailest1139493frailest
freest95318283fr_e_est
garbles104016923garb_les_
garbless11388253garb_less
greenest9312623greenest
greyest11348343gr_eyest
ireless72312243ir_eless
libelist10310823libelist
marbles114516653marb_les_
marbliest1336763marbliest
noblest93613563nob_lest
orbiest9312413orb_iest
orbless937493orb_less
praelect1247533praelect
prebless1236823prebless
preelect1249643preelect
prelect111013833pr_elect
pretest9517633pr_etest
rabbles113517973rabbles_
realest73322433_realest
reblent9614253_reblent
reelect911515633_reelect
reest54938093_r_e_est
relent64431853_r_elent
relet54749823_r_ele_t
relets64025673_r_elets
relist64628413_r_elist
renest64529713_r_enest
retest64028453_r_etest
revest94623603_r_evest
soberest10310353soberest
subtlest10511363subtlest
trebles9311443trebles_
treeless839283treeless
tubeless1037023tubeless
unblest9411813unb_lest
urbanest10117533urbanest
warbles123215563warb_les_

Search took 7 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.420425454.8
2DLD Change Limit146162916.37622923.8
3Display Results91910.0461978.3
 (SQL Overall)178691916.84226116.8
 
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.