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

78 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
barrister114573(None) 
barristers1244721barristers
arrester839252_arrester
banister10199972ba_nister
bannister1155372bannister
barrater10310142barr_ater
barrier94017732barri__er
arbiter939933_arbi_ter
arrested939153_arrested
arrestee849433_arrestee
arresters948193_arresters
arrestor847643_arrestor
arrises71617583_arris_es
arriver10117793_arri_ver
artiste73813693_artiste_
artistes83213343_artistes
assister836753_assister
baiter84422553ba__i_ter
ballaster1145973ballaster
baluster1037053ba_luster
banisher13169183ba_nisher
banisters11189473ba_nisters
bannisters1244323bannisters
baptistery1742173baptistery
barista9310813ba_rist_a
baristas1039723ba_ristas
barite84224813ba_ri_te_
barites94322333ba_ri_tes
barkier133814483barki__er
barmier114313043barmi__er
barnier93213673barni__er
barometer13189043barometer
barracker1744653barracker
barraters1138033barr_aters
barrator1048403barr_ator
barrener1038333barr_ener
barretor1046713barr_etor
barrette1039783barrette_
barrettes1149063barrettes
barriers104311883barri__ers
barter85525373ba_r__ter
baster85333593ba___ster
batiste939743ba_tiste_
batistes1039713ba_tistes
bister84922763b___ister
blister94415313b__lister
brisker134210293b__risker
bruiser9349573b_ruis_er
bruiter93710633b_rui_ter
burnisher1444823burnisher
burrier93613543burri__er
burster9310293b_ur_ster
canister101710853ca_nister
cannister1155723cannister
carrier93619583carri__er
chorister1487143chorister
farrier103514883farri__er
ganister9178993ga_nister
gannister1054173gannister
garnisher13195853garnisher
garroter956573garr_oter
grister83915413__grister
harrier104417753harri__er
harvester1544333harvester
lamister1037653la_mister
magister1136283ma_gister
marrier93817523marri__er
narrater838723narr_ater
palmister1345053palmister
parrier93717653parri__er
parroter1058203parr_oter
persister1146833persister
roister73516203__roister
tarrier74323173tarri__er
varistor1146383va_ristor
varnisher15195403varnisher
waister103812383wa__ister
warranter1245193warranter

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 Filter1786911486410.1701051123.5
2DLD Change Limit148641788.51617454.3
3Display Results78780.0332363.6
 (SQL Overall)178691788.71920494.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.