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

136 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
redbait103980(None) 
rebait8320401re_bait
redbaits1135901redbaits
rebaits9312572re_baits
redact9419042red_act
redbaited1344712redbaited
redbaiter1244152redbaiter
redbay1238332redba_y
redbays1336012redbays
redraft11310572redraft
redtail858712redtail
bait66556003___bait
bedfast1346413bedfast
bedrail1037253bedrail
bedsit9312843bed_sit
credit9315193cred__it
debit85727853de_b_it
edit54934863_ed__it
henbit111412003henb_it
mediant103516703mediant
megabit12117963megabit
pedant9319493ped_ant
predraft1447593predraft
rabat72832223r_aba_t
rabbit102914563r_abbit
radiant82817133radiant
react74634333re__act
readapt1039743readapt
readmit1039823readmit
reavail1035643reavail
rebaited11410543re_baited
rebar75420193re_ba_r
rebars84019833re_bars
rebate84424113re_bate
rebato83714683re_bato
rebid85121363re_b_id
reboant9315093reboant
reboil83814683re_boil
reboot84119333re_boot
rebuilt939973re_built
rebut75927383re_b_ut
recant83228683re_cant
recast83422773re_cast
rechart12314323rechart
recit75235103re__cit
reclaim1137753reclaim
recoat84024273recoa_t
recruit939773recruit
redacts10510943red_acts
redan66125013red_a_n
redans75421023red_ans
redate74124683red_ate
redbaiters1343603redbaiters
redbaiting1446263redbaiting
redbird1155263redbird
redbone1037973redbone
redbreast1243623redbreast
redbrick1742653redbrick
redbud10135803redb_ud
redbuds11144283redbuds
redbug10165473redb_ug
redbugs11134463redbugs
redcap1158493redca_p
redcaps1247073redcaps
redcoat10410883redcoat
reddest9311953reddest
redear73515173redea_r
redears82814453redears
redfin10310223red_fin
redia65524483red__ia
rediae74221993redia_e
redial74923113redia_l
redials84416883redials
redias74523603redia_s
redid74922393red__id
redip87816963red__ip
redipt94116743red_ipt
redoubt10167843redoubt
redout71820253red_out
redrafts1235603redrafts
redraw10269853redra_w
redrawn11245953redrawn
redraws11218473redraws
redreamt11127183redreamt
redroot8312903redroot
redshift1544613redshift
redshirt1245853redshirt
redskin1286023redskin
redstart949193redstart
redtails968003redtails
redware1139363redware
reedit7617223re_edit
reemit8717223re_emit
reenact9413003reenact
refit84230063re__fit
refract121311603refract
refrain10310043refrain
regain74517763re_gain
regnant8312843regnant
regraft11310153regraft
regrant8317323regrant
reheat94423943rehea_t
reknit10312533re_knit
relaid75518443re_laid
reliant7319243reliant
relit55340683re__lit
remail85017123re_mail
remain85919863re_main
remit75737223re__mit
remnant9312633remnant
renail65020763re_nail
reobtain1044623reobtain
repaid94716323re_paid
repaint9318363re_paint
repair84011463re_pair
repast83520633re_past
repeat85127213repea_t
replant93318533replant
reposit9315863reposit
reptant92817073reptant
resaid74517083re_said
resail64418733re_sail
resat55139683re_sa_t
reseat64131493resea_t
resit54241043re__sit
resplit9310373resplit
restart7320033restart
resubmit1243573resubmit
retail65522073re_tail
retain64523283re_tain
retract91318113retract
retrain7615423retrain
revisit10311373revisit
rewrapt12138113rewrapt
rubati8299693r_ubati
tidbit938493tidb_it

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.403443402.0
2DLD Change Limit1340271366.01622278.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911366.46527639.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.