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

102 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
borstals103747(None) 
borstal939041borstal_
bobstays1543342bobstays
borals86721912bor__als
dorsals84110852dors_als
mortals93914012mor_tals
portals94015562por_tals
postals93716382po_stals
aortal65217513aor_tal_
aortas65417783aor_ta_s
barbitals1345263barbitals
baristas1039723barista_s
barstools1143543barstools
barytas12378283baryta_s
berascals1343503berascals
bimetals1246953bimetals
boasters103915663boasters
boasts85017923boast__s
boatels93510233bo_atels
bobstay1443983bobsta_y
bobtails1245193bo_btails
bolsters103712453bolsters
bonitas939453bonita_s
bookstall1552893bookstall
bookstalls1652853bookstalls
boosters104013443boosters
boosts86115013boost__s
boral75831703bor__al_
boras75938303bor__a_s
borates94823013borat_es
bordels103911973bor_dels
boreal84817213bor_eal_
boreas85421733bor_ea_s
borneols1046343borneols
borsches1536003borsches
borschts1542853borschts
borshts1266543bors_hts
borts76735453bor_t__s
bortzes1838223bor_tzes
bostons9312903bo_stons
botas75328783bo__ta_s
botels84815803bo__tels
bridals1038623b_ridals
bristols1046773bristols
bromals1139743b_romals
brutal859383b_rutal_
burials93612083bur_ials
bursal84414823burs_al_
bursars94510893burs_ars
bursas85318273burs_a_s
bursters1038983bursters
bursts85116243burst__s
buttals938503b_uttals
coastal9411043coastal_
corals85325143cor__als
cordials1139633cordials
cornstalk1543943cornstalk
cornstalks1643083cornstalks
coronals103312913coronals
corrals93713853cor_rals
corsacs1139013cors_acs
costal85419513co_stal_
costars94218013co_stars
crystals1347173crystals
curtals93111623cur_tals
dorsal74613943dors_al_
dorsels84412583dors_els
dossals8379303do_ssals
forestal11410283forestal_
forestall1246913forestall
forestalls1345803forestalls
forestays1546623forestays
formals123312893for_mals
frontals1146273frontals
gorals76917653gor__als
hartals10313023har_tals
horntails12124823horntails
horsetails1344743horsetails
horstes104516113horst_es
horsts95817513horst__s
hostas94515833ho_sta_s
hostels103712323ho_stels
instals7611713_instals
marshals1337783marshals
morals85324643mor__als
morsels94112663mors_els
mortal84616853mor_tal_
mortars93411523mor_tars
normals92510903nor_mals
orals55826483_or__als
orbitals1045713_orbitals
ordeals878003_ordeals
portal84218463por_tal_
postal84317533po_stal_
ratals64219583__ratals
rorquals1773183rorquals
tarsals72512603tars_als
tortas64918253tor_ta_s
totals63115163to__tals
vestals104612333_vestals
worsteds1234483worsteds
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 Filter1786911461620.423422437.4
2DLD Change Limit1461621027.36019859.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.81322871.0
 
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.