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

83 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
bargemen134640(None) 
bargeman1345141bargeman
bagmen115412532ba_g_men
bargee94624442barge_e_
bargees105415872barge_es
barmen105418532bar__men
basemen1139082ba_semen
brakemen1644842brakemen
garagemen1363762garagemen
argument1158903_argument
axemen1547493_a_xemen
badgered1336213badgered
badmen114613833ba__dmen
bagman114613813ba_g_man
bailsmen1244623bailsmen
baleen8613053ba_le_en
bandsmen1356453bandsmen
barbered13259543barbered
barege94713543bar_ege_
bareges105212033bar_eges
bargain1079063barg_ain
barge85631023barg__e_
barged105822643barg__ed
bargello1144143bargello
barges94528253barg__es
barkeep1536363barke_ep
barman103519703bar__man
barreled1137843barreled
barren85317613bar__ren
barrener1038333barrener
bartered113113013bartered
barterer102711633barterer
baseman1138553ba_seman
basement12311493ba_sement
batmen104414303ba__tmen
batsmen1146883ba_tsmen
battement1357773battement
baymen134212003ba__ymen
bedemen12910183b_edemen
bergere1068913bergere_
bergeres1189113bergeres
birdmen1235833bir_dmen
bireme10310143bir_eme_
biremes1138773bir_emes
boardmen1344073boar_dmen
bogeymen1643633b_ogeymen
bogymen1534763b_ogymen
boogermen1443083boogermen
boogeymen1751983boogeymen
boogiemen1452043boogiemen
boogymen1643103boogymen
boreen8314313bor_e_en
brakeman1644313brakeman
burgee97120593burge_e_
burgees104915893burge_es
burgeon1036433burge_on
carageen1155633carage_en
careen84119493car_e_en
carmen104019343car__men
cavemen1437143ca_vemen
cragsmen1344763cragsmen
dragomen1245013dragomen
earthmen1346393earthmen
firemen1238773fir_emen
foremen12412923for_emen
freemen1238463_freemen
gagmen103910413ga_g_men
garageman1382913garageman
garbagemen1671773garbagemen
gatemen1047603ga_temen
hangmen1337383hang_men
horsemen1347483horsemen
liegemen1144133liegemen
marksmen1644533marksmen
oarsmen938093oar_smen
pargeted1238673pargeted
premen105017803_pr_emen
ragmen93712183ra_g_men
sagamen10127503sa_gamen
targeted1037483targeted
versemen1346853versemen
wiremen1236903wir_emen
yardmen1335423yar_dmen

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.1561145455.1
2DLD Change Limit146162837.62319173.8
3Display Results83830.0332515.2
 (SQL Overall)178691837.81222873.9
 
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.