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

203 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
birdmen123583(None) 
birdman1236671birdman
aidmen92610372ai_dmen
airmen82612352air_men
badmen114613832b_admen
barmen105418532bar_men
beadmen12299452beadmen
bidden104010792bi_dden
birchen14347882birchen
birded104414302bird_ed
birder94915492bird_er
birdie94013782birdie_
birdied11329432birdied
birdies104016212birdies
bireme10310142bireme_
biremes1138772biremes
bitumen1134502bitumen
boardmen1344072boardmen
bondmen1237892bondmen
burden9412472burd_en
firemen1238772firemen
herdmen13238452herdmen
kirkmen1232922kirkmen
wiremen1236902wiremen
yardmen1335422yardmen
admen84516183__admen
aidman92410623ai_dman
airman82414223air_man
airwomen1344823airwomen
badman113813843b_adman
bagmen115412533b_agmen
bailsmen1244623bailsmen
bandsmen1356453bandsmen
barde85330773bard_e_
barded105426423bard_ed
bardes95026933bard_es
bargemen1346403bargemen
barman103519703bar_man
barren85317613bar_ren
basemen1139083basemen
batmen104414303b_atmen
batsmen1146883batsmen
baymen134212003b_aymen
beadman12249153beadman
beadsmen1385883beadsmen
bedemen12910183bedemen
bellmen1138143bellmen
berime105317333berime_
berimed124912283berimed
berimes115216643berimes
berme96022943ber_me_
bermed115217723ber_med
bermes106023003ber_mes
bidder104114863bi_dder
biddies113514493biddies
bide76041483bi_d_e_
bided95424963bi_d_ed
bider85728373bi_d_er
bides85536773bi_d_es
bidet84935623bi_d_et
binder94422873bind_er
bindle94516263bindle_
bindles104016453bindles
biogen9310253bi_ogen
biome94916993bi_ome_
biomes103815253bi_omes
birched15349913birched
birches143412323birches
bird76128323bird___
birddog1282363birddog
birders103913263birders
birdfeed1542443birdfeed
birdieing1343033birdieing
birding114014923birding
birdlime1343563birdlime_
birdlimed1542043birdlimed
birdlimes1443093birdlimes
birds85421333bird__s
birdseed1243253birdseed
birdseye1441643birdseye
birdsong1272563birdsong
birkie124110133birkie_
birkies133712433birkies
birle75023633bir_le_
birled94416993bir_led
birler85715083bir_ler
birles84920643bir_les
birred94713203bir_red
birse74517403bir_se_
birses84717733bir_ses
birthed13228593birthed
bitchen14349733bitchen
bitten84715123bi_tten
bitumens1243523bitumens
boardman1344393boardman
boatmen1146913boatmen
bogymen1534763bogymen
bondman1238043bondman
bondsmen1345473bondsmen
bookmen15126263bookmen
bordel94514573bord_el
border94419973bord_er
boreen8314313bor_een
bowmen1399853b_owmen
brazen174812453b_razen
bren65629563b_r__en
bride86425533brid_e_
brides94423513brid_es
bridge103711883bridge_
bridged12339033bridged
bridges113911333bridges
bridle94115463bridle_
bridled113611143bridled
bridler103811073bridler
bridles104114473bridles
bridoon1046203bridoon
brimmed14386783brimmed
brimmer13348803brimmer
broken124011523b_roken
brome94421973b_rome_
bromes104719763b_romes
bromin102615693b_romin
brume95817983b_rume_
brumes106417073b_rumes
burdens1039713burd_ens
burdie93615023burdie_
burdies104117563burdies
burthen1236363burthen
bushmen1436303bushmen
busmen1039893b_usmen
carmen104019343car_men
cerumen1147763cerumen
dairymen1443313dairymen
deadmen11248573deadmen
diriment11410743diriment
duramen1096903duramen
fireman1249333fireman
firman112211343fir_man
firmed125411883fir_med
firmer114712443fir_mer
foramen12310533foramen
foremen12412923foremen
garden84215083gard_en
germen9612313ger_men
girded93712493gird_ed
girder84312063gird_er
girdle82110463girdle_
girdled10217453girdled
girdler9227313girdler
girdles92210003girdles
goodmen1135623goodmen
gripmen1235033gripmen
harden105718533hard_en
headmen13259513headmen
herdman13238423herdman
herdsmen1464833herdsmen
hidden11429743hi_dden
hitmen11239193hi_tmen
icemen1037893_icemen
ironmen936453_ironmen
jurymen1943133jurymen
kinsmen1335653kinsmen
kirkman1243773kirkman
landmen1038553landmen
leadmen10277903leadmen
liftmen1234233liftmen
limen75426033li__men
linden7411453lind_en
linemen938633linemen
linkmen1335363linkmen
madmen113511743_madmen
mermen10813813mer_men
midden104112853mi_dden
milden94113153mild_en
milkmen1565213milkmen
oarsmen938093oarsmen
oilmen848313oi_lmen
pikemen1535333pikemen
pirogen1038263pirogen
pitmen102510793pi_tmen
premen105017803_premen
ramen75625193__ramen
reedmen1038333reedmen
ridden83511723ri_dden
rodmen939713_rodmen
rumen74419503__rumen
sandmen1039413sandmen
seedmen1037683seedmen
sidemen1037943sidemen
siren54525823sir__en
surfmen1235993surfmen
swordmen1443003swordmen
tinmen82310393ti_nmen
titmen8239883ti_tmen
turfmen1244163turfmen
vimen104114753vi__men
warden104515513ward_en
widen94717973wi_d_en
wingmen1336103wingmen
wireman1237843wireman
woodmen1356053woodmen
workmen1635933workmen
yardman1335913yardman

Search took 7 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.1561145455.1
2DLD Change Limit1340272036.61020276.4
3Display Results2032030.0762671.1
 (SQL Overall)1786912036.84226116.8
 
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.