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 “arbalest” 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
arbalest103952(None) 
arbalests1144121arbalests
arbalist10313331arbalist
arbelest1049501arbelest
ablest84721832a_b_lest
arables91814972arables_
arbalists1148482arbalists
arbelests1143652arbelests
realest73322432_realest
urbanest10117532urbanest
abases85720773a_bases_
abates85825033a_bates_
abeles84719393a_beles_
ableist9311773a_b_leist
ables75935543a_b_les_
abrades10312073abrades_
aerialist9914263aerialist
alcahest1345353alcahest
alkahest1554023alkahest
almagest1146233almagest
ambages1269623ambages_
ambles105121863amb_les_
amplest11312333a_mplest
analyst10189323a_nalyst
anapest9311563a_napest
annalist8413753annalist
arabesk1332863ar_abesk
arable81821003arable__
arames84622573ar_ames_
arbores94016033arbores_
arborist10411613arborist
arbutes939703arbutes_
arcades101113193arcades_
areoles71016953areoles_
argalas84011093argalas_
argalis84214193argalis_
argals75517713argal_s_
argles75218483ar_gles_
argyles1136053argyles_
aridest8316143ar_idest
arles56735743ar__les_
armament1249633armament
armless9369943ar_mless
armlet84118193ar_mle_t
armlets94610063ar_mlets
armrest9310163ar_mrest
arrases71214543arrases_
arrest63722633ar__rest
artiest73121993ar_tiest
artless73712513ar_tless
artsiest879653artsiest
aubades1038753aubades_
baldest102313533__baldest
bales76250083__bales_
barbless12318713barb_less
barbules1238043barbules_
barest85327693__barest
basest84720493__basest
blest76431723__b_lest
braless92910563br_aless
bravest124211753br_avest
brawest123810483br_awest
broadest1138573broadest
bubales113513343bubales_
cabalist12314503cabalist
cabbalist1547643cabbalist
capablest1544893capablest
cruelest1059183cruelest
drabbest13295663drabbest
drollest937353drollest
frailest1139493frailest
garbages1238183garbages_
garbles104016923garb_les_
garbless11388253garb_less
gravest114011633gr_avest
grayest11489363gr_ayest
greatest939863greatest
halest94823273__halest
herbalist1449813herbalist
iratest7312483ir_atest
kabalist14410083kabalist
kabbalist1744613kabbalist
loyalest11146723loyalest
marbles114516653marb_les_
marbliest1336763marbliest
noblest93613563nob_lest
oralist7619633or_alist
orbiest9312413orb_iest
orbless937493orb_less
palest83926223__palest
parablast1347093parablast
parables121613563parables_
parbakes1638343parbakes_
rabbles113517973rabbles_
rales54947493_r_ales_
rarest65725483_r_arest
rawest93615063_r_awest
reales64934123_reales_
realist73225383_realist
shoalest1168913shoalest
stablest103312943stablest
stalest73720173_stalest
subtlest10511363subtlest
tribalist1149953tribalist
unbales92914863unbales_
unblest9411813unb_lest
urbanist10109073urbanist
verbalist1449503verbalist
warbles123215563warb_les_

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621097.62619166.3
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.09222082.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.