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

140 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
bombard143733(None) 
bombards1536491bombards
board85523002bo__ard
bollard103210502bollard
bombarded17123632bombarded
bombarder16143582bombarder
bombardon1652162bombardon
bombast1348222bombast
bombax1935752bomba_x
bombed134113872bomb_ed
bomber125014652bomber_
bombers134512592bombers
boobird1235232boobird
boxboard2044612boxboard
boyard125411282bo_yard
aboard9312613abo__ard
ambari103012173_ambari
ambary134010543_ambary
armband1265983armband
bard75648863___bard
bastard103012423bastard
bayard124411663b_ayard
beard86024963b__eard
bedboard14115723bedboard
bedward1497473bedward
beeyard1335523beeyard
blowhard1743733blowhard
boar66134293bo__ar_
boards94616933bo__ards
boars75229603bo__ars
boart78835933bo__art
boatyard1444073boatyard
bobbed104315833bo_bbed
bobber95016743bobber_
bobbers103614283bobbers
bobbery13438353bobbery
bobbled113811833bobbled
bodyboard1843303bodyboard
bogart9617193bo_gart
bolar75123473bo_lar_
bollards11339153bollards
bomb106927423bomb___
bombable1336263bombable
bombarders17153203bombarders
bombardier1752103bombardier
bombarding1843833bombarding
bombardons1752053bombardons
bombasts1444953bombasts
bombe115519313bomb__e
bombes124916823bomb_es
bombing143211393bombing
bomblet13412263bomblet
bombload1543143bombload
bombs115818823bomb__s
bombycid2042073bombycid
bombyx2232693bomb_yx
boneyard1475323boneyard
boobed114514873boob_ed
boobirds1344183boobirds
boxball18155323boxball
boxboards2144263boxboards
boxcar1734753boxcar_
boxcars1834773boxcars
boyar106013763bo_yar_
boyards13399323bo_yards
boyars115611983bo_yars
briard94311293b_riard
browband1643883browband
bulbar1039583bulbar_
bumbled144113043bumbled
busbar1038453busbar_
busbars1138153busbars
bustard10389723bustard
buzzard1844273buzzard
collard103712923collard
colombard1643153colombard
combat12316753comba_t
combated1539823combated
combats13311683combats
combed135516543comb_ed
comber125118503comber_
combers134516623combers
command14399213command
compare135814993compare
compared153811823compared
compart134016003compart
costard104113353costard
coward12411673co_ward
cowbird1534433cowbird
dotard839053do_tard
embar94011603_embar_
embark14458523_embark
embars103812883_embars
forbad122710503forba_d
forbare122310513forbare
forward1438293forward
foulard11257283foulard
gabbard1336553gabbard
goliard936073goliard
hoard94918313ho__ard
holard10410573ho_lard
hombre13309303homb_re
homburg1543073homburg
homeward1745323homeward
imbark14347863_imbark
lobar7313013lo_bar_
lumbar103610593lumbar_
lumbars11289763lumbars
mimbar1297493mimbar_
mimbars1397383mimbars
mopboard1543983mopboard
nomad86016183nom_a_d
omber95316443_omber_
ombers104214403_ombers
ombre94111803_omb_re
onboard1046503_onboard
onward1039053_onward
pochard1537363pochard
pollard103511143pollard
poniard1037583poniard
poulard10299733poulard
roband92310723ro_band
rumbaed12287493rumbaed
sambaed1238303sambaed
sambar103914163sambar_
sambars115113843sambars
somber103714003somber_
sombre10729473somb_re
tabard9313333_tabard
tombac12258883tomba_c
tomback17227743tomback
tombacs13248443tombacs
tombak14237753tomba_k
tombaks15246863tombaks
tombal102311023tomba_l
tombed113812133tomb_ed
toward10311063to_ward
wombat1339863womba_t
wombats1435893wombats
wombed14419233womb_ed

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.423422437.4
2DLD Change Limit1340271405.81323056.4
3Display Results1401400.0602333.3
 (SQL Overall)1786911406.29628381.7
 
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.