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

101 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
bombards153649(None) 
bombard1437331bombard_
boards94616932bo__ards
bollards11339152bollards
bombarded17123632bombarded
bombarder16143582bombarder
bombarders17153202bombarders
bombardon1652162bombardon
bombardons1752052bombardons
bombasts1444952bombasts
bombers134512592bomber_s
boobirds1344182boobirds
boxboards2144262boxboards
boyards13399322bo_yards
ambaris113112163_ambaris
armbands1355143armbands
bards87139643___bards
bastards113310313bastards
bayards13379683b_ayards
beards94116673b__eards
bedboards15114873bedboards
bedwards1596393bedwards
beeyards1444593beeyards
blowhards1843273blowhards
board85523003bo__ard_
boars75229603bo__ar_s
boarts84716873bo__arts
boatyards1543963boatyards
bobbers103614283bobber_s
bodyboards1943243bodyboards
bogarts1047743bo_garts
bollard103210503bollard_
bombable1336263bombable
bombardier1752103bombardier
bombardiers1851563bombardiers
bombarding1843833bombarding
bombast1348223bomba_st
bombax1935753bomba__x
bombed134113873bomb_ed_
bomber125014653bomber__
bombes124916823bomb__es
bombings15266493bombings
bomblets1436023bomblets
bombloads1642443bombloads
bombs115818823bomb___s
bombycids2151443bombycids
bombyxes2442603bombyxes
boneyards1584623boneyards
boobird1235233boobird_
boxballs19144233boxballs
boxboard2044613boxboard_
boxcars1834773boxcar_s
boyard125411283bo_yard_
boyars115611983bo_yar_s
briards10398553b_riards
browbands1743403browbands
busbars1138153busbar_s
bustards11308513bustards
buzzards1943613buzzards
collards113310193collards
colombards1752483colombards
combats13311683comba_ts
combers134516623comber_s
commands15318823commands
compares143816433compares
comparts144210833comparts
costards113510793costards
cowards1339613co_wards
cowbirds1644043cowbirds
dotards937253do_tards
embarks15337353_embarks
embars103812883_embar_s
forwards1537043forwards
foulards12266463foulards
gabbards1445753gabbards
goliards1045133goliards
hoards104912623ho__ards
holards1148433ho_lards
hombres14369873homb_res
homburgs1642733homburgs
homewards1844513homewards
imbarks15326613_imbarks
lumbars11289763lumbar_s
mimbars1397383mimbar_s
mopboards1643753mopboards
nomads94711603nom_a_ds
ombers104214403_omber_s
ombres103911143_omb_res
onwards1137173_onwards
pochards1646853pochards
pollards11299523pollards
poniards1145823poniards
poulards11288233poulards
robands10219863ro_bands
sambars115113843sambar_s
tabards10310383_tabards
tombacks18216463tombacks
tombacs13248443tomba_cs
tombaks15246863tomba_ks
towards1138783to_wards
wombats1435893womba_ts

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 Filter1786911461620.440406115.9
2DLD Change Limit1461621016.32623105.0
3Display Results1011010.0333060.6
 (SQL Overall)1786911016.79926282.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.