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

144 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
bilsteds113427(None) 
bilsted1038031bilsted_
bisters93922612bi_sters
blisters104015082blisters
bolsters103712452bolsters
oilseeds943702oilseeds
airsheds12274963airsheds
allseeds943393allseeds
balusters1136643balusters
basted95227233b_asted_
basters94930303b_asters
bastes85330383b_aste_s
bedsteads1352693bedsteads
belated103520013belated_
beloveds14153963beloveds
belted94020633bel_ted_
belters93819413bel_ters
besteads11307123b_esteads
bested94922763b_ested_
bestuds10326753b_estuds
biased94012223bias_ed_
biases84618433bias_e_s
biasness1035813biasness
biassed10418703biassed_
biasses94911653biasse_s
bighted142810923bighted_
bigoted11258403bigoted_
bilayers13296923bilayers
bilbies114712343bilbie_s
bilboes114410243bilboe_s
biles75542143bil__e_s
bilevels1343693bilevels
bilged105513183bil_ged_
bilges94915633bil_ge_s
bilked134012943bil_ked_
bilkers134711863bil_kers
billed94224903bil_led_
billers94720833bil_lers
billeted1137643billeted_
billeters1136873billeters
billets94516153bil_lets
billheads1564253billheads
billies93923503billie_s
bilobed1235913bilobed_
bimesters1336343bimesters
bipeds11458053bi__peds
birdseeds1342243birdseeds
birses84717733birs_e_s
bises75435623bi_s_e_s
bister84922763bi_ste_r
bistred103311853bi_stred_
bistres94017213bi_stres
bistros92810983bi_stros
biters83925243bi__ters
bites75641173bi__te_s
bitted94418483bi_tted_
bitters94920363bi_tters
blasted104213473blasted_
blasters104116143blasters
bleeds95211593b_l_eeds
blissed10388373blissed_
blisses94911513blisse_s
blister94415313bliste_r
blistery13418713blistery
blites84721213b_lite_s
blusters104413893blusters
boasted104113743boasted_
boasters103915663boasters
bobsleds13304383bobsleds
boletes9316063bolete_s
bolster93713423bolste_r
bolted94617803bol_ted_
bolters94017803bol_ters
boosted104111983boosted_
boosters104013443boosters
bugseeds1242843bugseeds
burseeds1134783burseeds
bursted1039423bursted_
bursters1038983bursters
busted95123153b_usted_
busters94724133b_usters
cisted95217523ci_sted_
diastems11226523diastems
diasters92913183diasters
diesters92513603diesters
dilated93115823dilated_
dilaters92513063dilaters
dilates83220663dilate_s
diluted9248933diluted_
diluters9288113diluters
dilutes82911973dilute_s
distends10339823di_stends
fibsters13126413fibsters
fileted1159093fileted_
filisters1237003filisters
filters103816553fil_ters
fisted104218703fi_sted_
frosteds12305653frosteds
glistens9366593glistens
glisters93912603glisters
hilted104016043hil_ted_
hipsters13268793hipsters
histed104420243hi_sted_
holsters113211943holsters
insteps936573_insteps
jilted144111353jil_ted_
jilters144211963jil_ters
kiesters123310153kiesters
kilted113613833kil_ted_
kilters113813603kil_ters
klisters123910483klisters
lilted73715373lil_ted_
limiteds11184543limiteds
linseeds944733linseeds
listed74322833li_sted_
listees73416673li_stees
listels74212433li_stels
listens74014133li_stens
listers74026533li_sters
malteds10377603mal_teds
milksheds1941733milksheds
milted93919943mil_ted_
milters93619093mil_ters
minsters103813923minsters
missteps12156143missteps
misted93625823mi_sted_
mistends11419593mi_stends
misters93927513mi_sters
oersteds934373oersteds
oilseed835783oilseed_
piasters102912813piasters
pilasters1138223pilasters
piloted10310323piloted_
pilsners1035533pilsners
pistes85325633pi_ste_s
silted74020013sil_ted_
sisters73721593si_sters
tilted74616863til_ted_
tilters73315953til_ters
tipsters10278513tipsters
ulsters72711983_ulsters
wilted103915713wil_ted_
wisted104120273wi_sted_
worsteds1234483worsteds

Search took 8 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.563317390.8
2DLD Change Limit1461621447.32619951.1
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.93522519.3
 
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.