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

169 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
borstal93904(None) 
borstals1037471borstals
aortal65217512aor_tal
bobstay1443982bobstay
boral75831702bor__al
boreal84817212bor_eal
brutal859382b_rutal
bursal84414822burs_al
coastal9411042coastal
costal85419512co_stal
dorsal74613942dors_al
forestal11410282forestal
mortal84616852mor_tal
portal84218462por_tal
postal84317532po_stal
aboral8314373abor__al
agrestal945653agrestal
aorta55922573aor_ta_
aortae65115473aor_tae
aortas65417783aor_tas
artal55525473_ar_tal
barbal104016663bar_bal
barbital1247053barbital
barista9310813barista_
baristas1039723baristas
barstool1044233barstool
baryta114310293baryta_
barytas12378283barytas
basal75722283b_as_al
berascal1244853berascal
bestial9311643b_estial
bicoastal1352203bicoastal
bimetal1138433bimetal
boast75935703boast__
boasted104113743boasted
boaster94616433boaster
boastful1344853boastful
boasts85017923boast_s
boatel84314093bo_atel
bobstays1543343bobstays
bobtail1146553bo_btail
bolster93713423bolster
bonita8312943bonita_
bonitas939453bonitas
bonsai838463bons_ai
bookstall1552893bookstall
boost75132473boost__
boosted104111983boosted
booster94314553booster
boosts86115013boost_s
bora66141633bor__a_
borals86721913bor__als
boras75938303bor__as
borate85026153borat_e
borated104116363borated
borates94823013borates
borax145918723bor__ax
bordel94514573bor_del
boreas85421733bor_eas
borneol936823borneol
borsch1336133bors_ch
borscht1445993borscht
borsht11813503bors_ht
borshts1266543borshts
bort65960963bor_t__
borts76735453bor_t_s
borty105522833bor_t_y
bortz165722203bor_t_z
boston8513043bo_ston
bota66236503bo__ta_
botas75328783bo__tas
botel75121863bo__tel
bridal9511453b_ridal
bristol937043bristol
bromal10313653b_romal
brumal1049503b_rumal
burghal1335073burghal
burial84117623bur_ial
bursa74921523burs_a_
bursae84515603burs_ae
bursar85413253burs_ar
bursas85318273burs_as
bursate94111203bursate
burst75332243burst__
bursted1039423bursted
burster9310293burster
bursts85116243burst_s
byssal1134993b_yssal
coital84117053co_ital
coral76033453cor__al
cordial10312953cordial
corneal94414503corneal
cornstalk1543943cornstalk
cornual94210173cornual
coronal94115763coronal
corral83616253cor_ral
corsac10410173cors_ac
coryzal2154823coryzal
costa75523733co_sta_
costae85319683co_stae
costar85518613co_star
crestal9312133crestal
crustal939023crustal
crystal1237433crystal
curtal83914543cur_tal
distal73615773_distal
dorsa64617283dors_a_
dorsad8408973dors_ad
dorsals84110853dors_als
dorsel75315503dors_el
dossal75510303do_ssal
dotal64919623do__tal
festal94213563_festal
foetal9311883fo_etal
fontal9313143fo_ntal
forestall1246913forestall
forestay1448193forestay
forestial1247233forestial
formal113215203for_mal
frontal1038363frontal
goral65125753gor__al
hartal9415473har_tal
horal86328683hor__al
horntail11105033horntail
horsetail1244693horsetail
horst85833513horst__
horste94817413horst_e
horstes104516113horstes
horsts95817513horst_s
hosta85917833ho_sta_
hostas94515833ho_stas
hostel93914153ho_stel
instal6712193_instal
locustal10325223locustal
loessal744393loessal
loral55927823lor__al
loreal63814313lor_eal
marital92314183marital
marshal1238973marshal
moral75533433mor__al
morsel85815893mors_el
mortals93914013mor_tals
mortar83812043mor_tar
normal83213533nor_mal
notal55221353no__tal
octal71214723_o_ctal
oral47638123_or__al
orbital936923_orbital
ordeal779253_ordeal
osteal6312963_o_steal
portals94015563por_tals
postals93716383po_stals
ratal55025113__ratal
rorqual1663573rorqual
rostral7311333ro_stral
scrotal938493scrotal
somital939403somital
sororal7310653sororal
sorta57125413sor_ta_
stratal72710603stratal
tarsal63315273tars_al
torta55925353tor_ta_
tortas64918253tor_tas
total55321823to__tal
versal93013753vers_al
vestal94615573_vestal
worst86330133worst__
worsted1138013worsted
worsts96014333worst_s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271697.09318895.7
3Display Results1691690.0632682.5
 (SQL Overall)1786911697.56223630.1
 
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.