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

123 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
barmaid123820(None) 
barmaids1345941barmaids
aramid93315612_aramid
bandaid11310482bandaid
bargain1079062bargain
barman103519702barma_n
barmie103816392barm_ie
braid85822262b_r_aid
mermaid1297852mermaid
abroad9310943abroa_d
afraid1049723_afraid
agamid103710693_agamid
airmail946213airmail
amain74922913_a_main
amid77036353_a_m_id
aramids102810513_aramids
arid57642713_ar__id
armada938783_armada
armband1265983_armband
armed86324433_arm_ed
armpit10811093_armpit
aroid65428343_ar_oid
baaed85218163ba__aed
badland1147653badland
badman113813843badma_n
bagman114613813bagma_n
ballad94315323balla_d
bammed133913243ba_mmed
banzai1737653banzai_
banzais1837163banzais
barbal104016663barba_l
barbaric1446373barbaric
barbate11314543barbate
barbed115121313bar_bed
barbie105018353bar_bie
barca91319433barca__
barcas101016603barca_s
bard75648863bar___d
barded105426423bar_ded
bardic11312923bar_dic
bared85144483bar__ed
barefit1249723barefit
barehand1446153barehand
barfed125416383bar_fed
bargained1344953bargained
bargains1178643bargains
barged105822643bar_ged
baric96125693bar__ic
barked135027313bar_ked
barm86739603barm___
barmen105418533barm_en
barmier114313043barmier
barms96128463barm__s
barmy125218763barm__y
barned95623583bar_ned
barnyard1443783barnyard
barrack1538253barrack
barrage10710843barrage
barraged1297683barraged
barred95725793bar_red
barrio8312573bar_rio
bartend1038753bartend
barware12610703barware
barytic1437823barytic
basmati1148233basmati
basmatis1247343basmatis
bastard103012423bastard
batman105214063batma_n
bayard124411663ba_yard
bayman133712703bayma_n
bermed115217723berm_ed
bondmaid1444323bondmaid
brad75234343b_r_a_d
braids95015693b_r_aids
brail75525553b_r_ail
brain76229383b_r_ain
brand85124493b_r_and
bread85523113b_rea_d
briard94311293b_riard
broad84817693b_roa_d
bromid112612893b_romid
byroad1236623byroa_d
camail10314833ca_mail
carabid12311333carabid
carman103920743carma_n
carotid102014833carotid
caryatid1447953caryatid
cormoid12310403cormoid
dairymaid1651803dairymaid
dermoid1138523dermoid
earmark1345653earmark
farad95720673far_a_d
farmed125117653farm_ed
farmhand1743563farmhand
farmland1454233farmland
farmyard1742833farmyard
gardai839663gardai_
garland948703garland
gormand1157453gormand
haemoid1337203haemoid
handmaid1546133handmaid
harmed125218833harm_ed
harmin113117393harm_in
hermai118912863hermai_
karma113415003karma__
karmas123013733karma_s
karmic1438113karm_ic
maid75537663___maid
maraud938943mar_aud
mermaids1355753mermaids
navaid1037653na_vaid
naysaid1145313naysaid
parfait12312053parfait
parotid102915513parotid
pearmain1245833pearmain
pyramid1547513pyramid
raid55243073__r_aid
sarcoid10310453sarcoid
tarmac10310333tarma_c
tarmacs1138323tarmacs
taxpaid1743093taxpaid
warmed124516893warm_ed
waylaid1445093waylaid

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.390458182.1
2DLD Change Limit1340271236.94019312.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.37624226.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.