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

137 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
birdman123667(None) 
birdmen1235831birdmen
aidman92410622ai_dman
airman82414222air_man
badman113813842b_adman
barman103519702bar_man
beadman12249152beadman
boardman1344392boardman
bondman1238042bondman
fireman1249332fireman
firman112211342fir_man
herdman13238422herdman
kirkman1243772kirkman
wireman1237842wireman
yardman1335912yardman
adman84517903__adman
aidmen92610373ai_dmen
airmen82612353air_men
airwoman1344673airwoman
badmen114613833b_admen
bagman114613813b_agman
bailsman1245003bailsman
bandsman1346753bandsman
barchan1469133barchan
bargeman1345143bargeman
barmen105418533bar_men
baseman1138553baseman
batman105214063b_atman
batsman1157993batsman
bayman133712703b_ayman
beadmen12299453beadmen
beadsman1355613beadsman
bedamn1137813b_edamn
bedeman12168843bedeman
bedpan1137583b_edpan
bellman1137183bellman
bidden104010793bi_dden
bima86723833bi__ma_
bimah127013273bi__mah
bimas95521743bi__mas
biradial1167713biradial
birchen14347883birchen
bird76128323bird___
birdbath1643173birdbath
birdbrain1452323birdbrain
birdcage1443513birdcage
birdcall1343693birdcall
birddog1282363birddog
birded104414303bird_ed
birder94915493bird_er
birders103913263birders
birdfarm1642873birdfarm
birdie94013783bird_ie
birdied11329433birdied
birdies104016213birdies
birding114014923birding
birds85421333bird__s
birdsong1272563birdsong
bireme10310143birem_e
biremes1138773biremes
biriani945643bir_iani
biryani1244033bir_yani
bitmap1235613bi_tmap
bitumen1134503bitumen
boardmen1344073boardmen
boatman1147053boatman
bogyman1544933bogyman
bondmen1237893bondmen
bondsman1345693bondsman
bookman15136483bookman
bowman13129853b_owman
bran65740383b_r__an
bridal9511453brid_al
bridoon1046203bridoon
brogan9311043b_rogan
bromal10313653b_romal
bromin102615693b_romin
brumal1049503b_rumal
buran75225303bur__an
burden9412473burd_en
bushman1455693bushman
busman10310253b_usman
carman103920743car_man
dairyman1443493dairyman
deadman11238423deadman
firemen1238773firemen
firepan1236983firepan
firmans12238523fir_mans
foreman12312363foreman
german9611983ger_man
goodman1135933goodman
gripman1234463gripman
hardpan1336443hardpan
headman13229633headman
herdmen13238453herdmen
herdsman1465643herdsman
hitman112710223hi_tman
iceman1037853_iceman
ironman936613_ironman
jordan1468063jord_an
juryman1943583juryman
kinsman1335963kinsman
kirkmen1232923kirkmen
landman1038923landman
leadman10237843leadman
liftman1244063liftman
liman75921603li__man
lineman939123lineman
linkman1335393linkman
lurdan738363lurd_an
madman113712383_madman
merman10513863mer_man
milkman1544913milkman
oarsman937733oarsman
oilman839483oi_lman
pikeman1535523pikeman
pitman102412123pi_tman
preman104117453_preman
reedman1037723reedman
reman75730153__reman
rodman949713_rodman
roman75424823__roman
sandman10310173sandman
seedman1037373seedman
sideman1037973sideman
sirdar7269103sird_ar
surfman1236203surfman
swordman1443403swordman
tinman82411143ti_nman
titman82711003ti_tman
turfman1243983turfman
viridian1245103viridian
wingman1336383wingman
wiremen1236903wiremen
woodman1336313woodman
workman1635613workman
yardmen1335423yardmen

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 Limit1340271376.59320328.7
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.79526297.4
 
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.