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

98 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
bitmaps134425(None) 
bitmap1235611bitmap_
bimahs13508302bi_mahs
bimas95521742bi_ma_s
biomass1155992biomass
pitmans11188742pitmans
ataps76414833_at_aps
atmans84413963_atmans
atmas75721013_atma_s
baps86040843b___aps
bathmats1545933bathmats
batman105214063batma_n
becaps123811403b_ecaps
beleaps1138053beleaps
bemas96424283b_ema_s
betas75528763bet_a_s
betrays12127823betrays
bettas84913923betta_s
bewraps14135403bewraps
bias64738173bi__a_s
biceps12447713bi_ceps
bima86723843bi_ma__
bimah127013273bi_ma_h
bimbos124610523bi_mbos
biogas94310913bioga_s
biomes103815253biom_es
biotas84313923biota_s
bishops1437033bishops
bitches144117063bitches
biters83925243bit_ers
bites75641173bit__es
bitmapped1841433bitmapped
bits66148173bit___s
bitters94920363bitters
bitts75022593bit__ts
bitumens1243523bitumens
blimps12588153blim_ps
botas75328783bot_a_s
bromals1139743bromals
bumps115921143b_um_ps
burlaps1156253burlaps
buttals938503buttals
catnaps1197033catnaps
citrals91111673citrals
dismals102010243dismals
dismays13237433dismays
ditas65923673dit_a_s
entraps9109763entraps
firmans12238523firmans
gimmals12225823gimmals
gimps105915203gi_m_ps
hetmans12187593hetmans
hitman112710223hitma_n
imams91511113_i_mams
imps86221123_i_m_ps
kidnaps1453323kidnaps
kismats13257843kismats
kitbags1443883kitbags
limans84816303li_mans
limas75627633li_ma_s
limpas105513083li_mpas
limps95522673li_m_ps
litas54923773lit_a_s
lithops12307253lithops
litmus836323litm_us
maps86141053___maps
mishaps1438723mishaps
outmans92413283outmans
petnaps1145033petnaps
pimas94725103pi_ma_s
pimps114616983pi_m_ps
pitas77427673pit_a_s
pitman102412123pitma_n
pitsaws1234993pitsaws
pittas86014523pitta_s
remaps105012873_remaps
ripraps1134943ripraps
rituals738353rituals
satraps95011643satraps
sigmas94111363sigma_s
simars84916933si_mars
simas75727553si_ma_s
simps94719763si_m_ps
sitars65417593sit_ars
situps8538783sit_ups
stamps105614023_stamps
straps87721783_straps
tamps95524093__tamps
taps66050683__t_aps
titans63414913tit_ans
titians72710453titians
titman82711003titma_n
tittups933353tittups
traps75727483__traps
vitals94514303vit_als
wataps11248683wat_aps
wimps125213803wi_m_ps
witans93412933wit_ans

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.406440125.6
2DLD Change Limit134027987.47017942.0
3Display Results98980.0303266.7
 (SQL Overall)178691987.90622601.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.