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

155 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
bitmap123561(None) 
bitmaps1344251bitmaps
batman105214062batman
bima86723832bi_ma_
bimah127013272bi_mah
bimas95521742bi_mas
hitman112710222hitman
pitman102412122pitman
titman82711002titman
aidman92410623aidman
airman82414223airman
atap66722453_at_ap
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
badman113813843badman
bagman114613813bagman
bap76455843b___ap
barman103519703barman
bateau8810563bateau
bathmat14510143bathmat
batmen104414303batmen
batsman1157993batsman
bayman133712703bayman
becap114315053b_ecap
beleap10410283beleap
bema85825253b_ema_
bemas96424283b_emas
beta66234133bet_a_
betas75528763bet_as
betray111511443betray
betta74916843betta_
bettas84913923bettas
bewrap13157053bewrap
bias64738163bi__as
biaxal1536093biaxal
bicep115413543bi_cep
bigamy1436343bigamy
bimahs13508303bi_mahs
bimbo114811873bi_mbo
binal75323823bi_nal
biogas94310913biogas
biomass1155993biomass
biome94916993biom_e
biomes103815253biomes
biota74516823biota_
biotas84313923biotas
birdman1236673birdman
bishop1336943bishop
bit57070903bit___
bitch125017763bit_ch
bitchy16479203bitchy
bite66547003bit__e
biter75030033bit_er
biters83925243biters
bites75641173bit_es
biting95321823biting
bitmapped1841433bitmapped
bits66148163bit__s
bitsy104511303bit_sy
bitt65545813bit__t
bitted94418483bitted
bitten84715123bitten
bitter84622673bitter
bitts75022593bit_ts
bitty106119173bit_ty
bitumen1134503bitumen
blimp115612943blim_p
boatman1147053boatman
bota66236503bot_a_
botas75328783bot_as
bowman13129853bowman
bromal10313653bromal
brumal1049503brumal
bump106228243b_um_p
burlap1098353burlap
busman10310253busman
catnap1098383catnap
citral81113893citral
dismal92412243dismal
dismay12229473dismay
dita56032523dit_a_
ditas65923673dit_as
entrap8710563entrap
firman112211343firman
giddap1143413giddap
gimmal11247513gimmal
gimp96124043gi_m_p
hetman112510603hetman
hiemal11339503hiemal
hitmen11239193hitmen
imam81718333_i_mam
imp76626973_i_m_p
jimp155618463ji_m_p
kidnap1334193kidnap
kismat123011673kismat
kitbag1334973kitbag
liftman1244063liftman
lima65734133li_ma_
liman75921603li_man
limas75627633li_mas
limp88432493li_m_p
limpa97014463li_mpa
litai55216363lit_ai
litas54923773lit_as
litmus836323litmus
map77255123___map
midcap1336473midcap
mishap1338863mishap
mitral81314323mitral
oilman839483oilman
outman83115033outman
petnap1037423petnap
pima85428653pi_ma_
pimas94725103pi_mas
pimp106024903pi_m_p
pita65436433pit_a_
pitas77427673pit_as
pitmans11188743pitmans
pitmen102510793pitmen
pitsaw1135613pitsaw
pitta75018693pitta_
pittas86014523pittas
potman102813573potman
remap95418103_remap
riprap1055513riprap
ritual6310623ritual
satrap86212553satrap
sigma84513833sigma_
sigmas94111363sigmas
sima64730783si_ma_
simar74920813si_mar
simas75727553si_mas
simp85228773si_m_p
sitar54820543sit_ar
situp74414063sit_up
stamp95217363_stamp
strap77925263_strap
tamp86133003__tamp
tap57663873__t_ap
tinman82411143tinman
titan53318173tit_an
titian62512663titian
titmen8239883titmen
tittup834203tittup
trap67532803__trap
vita75828523vit_a_
vitae84217633vit_ae
vital84819673vit_al
vitta85015173vitta_
vittae93911003vittae
watap102111673wat_ap
wimp115521523wi_m_p
witan83816503wit_an
withal1238933withal

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161555.29621283.2
3Display Results1551550.0463369.6
 (SQL Overall)1786911555.71531267.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.