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

158 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
redbug1016547(None) 
bedbug12193971bedbug
redbud10135801redbud
redbugs11134461redbugs
bedbugs13193502bedbugs
bedrug10164952bedrug
debug94210062de_bug
mudbug1243252mudbug
rebus75721112re_bus
rebut75927382re_but
rebuy104714682re_buy
redbay1238332redbay
redbuds11144282redbuds
reding83825562reding
redleg839272redleg
redout71820252redout
redub84212412red_ub
redubs9358382redubs
redux133811102red_ux
bedaub1146033bedaub
bedrugs11194283bedrugs
bedu75923693bed_u_
bug65340743___bug
ceding104014803ceding
debag94212303de_bag
debugs10467823de_bugs
debut86024143de_but
dorbug1034953dorbug
drug65718133__drug
dug58138693__d_ug
feedbag14112973feedbag
firebug1383793fire_bug
goldbug1242103goldbug
greenbug1242633greenbug
humbug1434803humbug
ladybug1441473ladybug
medium113711623medium
medius93613283medius
mudbugs1342853mudbugs
prebuy1357423pre_buy
prodrug1142953prodrug
radium93513293radium
radius73914873radius
ragbag1045463ragbag
ratbag956563ratbag
reading93327213reading
readout8615513readout
reb55844963re_b__
rebar75420193re_bar
rebbe9313163re_bbe
rebbes10313533rebbes
rebec94416543re_bec
rebel73421293re_bel
rebid85121363re_bid
rebop9313283re_bop
rebs65733563re_b_s
rebuff1437023re_buff
rebuke124010123re_buke
rebury11349213re_bury
rebuts84015193re_buts
rebuys11428783re_buys
recoup10810373recoup
rectum103411283rectum
rectus83314633rectus
recur74116843re_cur
recut74729243re_cut
red46755803red___
redact9419043redact
redan66125013red_an
redans75421023redans
redate74124683redate
redbait1039803redbait
redbays1336013redbays
redbird1155263redbird
redbone1037973redbone
redcap1158493redcap
redd66323173red__d
redded94019553redded
redden83613623redden
redder83918143redder
redding103218513redding
reddle83815913reddle
redds74617833red_ds
rede55037673red__e
redear73515173redear
reded74829123red_ed
redeem9311533redeem
redefy13388763redefy
redeny102712733redeny
redes65139133red_es
redeye103811793redeye
redfin10310223redfin
redia65524483red_ia
rediae74221993rediae
redial74923113redial
redias74523603redias
redid74922393red_id
redip87816963red_ip
redips93713843redips
redipt94116743redipt
redlegs936823redlegs
redly94217203red_ly
redo56029363red__o
redock134311543redock
redoes74623773redoes
redoing93516733redoing
redon65424883red_on
redone74820053redone
redons75222183redons
redos65126763red_os
redoubt10167843redoubt
redound968173redound
redouts81411663redouts
redowa1038453redowa
redox134714233red_ox
redraw10269853redraw
redrew10309513redrew
redry94314363red_ry
reds56042863red__s
redtop937973redtop
reduce9713253reduce
redwing122811983redwing
redye94413473red_ye
redyed114611243redyed
redyes104214093redyes
reedbuck1742673reedbuck
reeding94124133reeding
reflag1098083reflag
reflux16315413reflux
refuge105312613re_fuge
reg46146493re___g
regauge945813regauge
regius7311923regius
reglue739703reglue
regnum957163regnum
rehang1039823rehang
rehung1036343rehung
rejig133810123re_jig
rending93924263rending
renig64518913re_nig
repeg84015053re_peg
repour8310993repour
repugn946493re_pugn
rerig64018483re_rig
rerun58722153re_run
rescue8313003rescue
retag63618413re_tag
revue81114453re_vue
riding84325963riding
rubus76415063r_ubus
rug46039153r___ug
seabag938473seabag
sebum93814553se_bum
sedum84115573sed_um
tedium9269873tedium
uredium1076693uredium
zebu153414723ze_bu_
zebus164610053ze_bus

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 Limit1127161585.11022057.9
3Display Results1581580.0632507.9
 (SQL Overall)1786911585.54632219.8
 
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.