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

172 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
redbone103797(None) 
redbones1137591redbones
redone74820051red_one
debone93714782de_bone
rebore86625652re_bore
redline84218832redline
redon65424882red_on_
redons75222182red_ons
redrove11249422redrove
reshone102414162reshone
rezone153814782re_zone
aedine73218393aed_ine
bedsore1057803bedsore
begone9512133be_gone
bone65949323___bone
deboned113411633de_boned
deboner103110483de_boner
debones103315113de_bones
depone93616553de_pone
done55747913__d_one
drone65324983__drone
ebon66821103_e_bon_
ebons74316093_e_bons
ebony104511513_e_bony
evzone1894683_evzone
foredone1249733fored_one
hambone1439313hambone
henbane1237353henbane
hexone16289233he_xone
hipbone1445923hipbone
jawbone19134443jawbone
ketone105014533ke_tone
ladrone83611873ladrone
leone55018823le__one
madrone102812663madrone
neurone739433neurone
padrone102512073padrone
peptone11310763peptone
pinbone1138183pinbone
rabboni1144803rabboni
radome9511873rad_ome
radon64620503rad_on_
radons74118533rad_ons
rawboned14114253rawboned
reason62616333reason_
reasoned9410733reasoned
reasoner849343reasoner
reasons72514943reasons
reawoke14397443reawoke
rebate84424113re_bate
rebbe9313163re_b_be
rebind94416933re_bind
reboant9315093re_boant
rebody1238153re_body
reboil83814683re_boil
rebook125213203re_book
reboot84119333re_boot
rebop9313283re_bo_p
rebops10311433re_bops
rebored105015883re_bored
rebores95319163re_bores
reborn810016963re_born
rebound1058583re_bound
rebozo1737323re_bozo
rebuke124010123re_buke
recane83022873re_cane
rechose121312043rechose
reckon123010543reckon_
reckoned1546953reckoned
reckoner1446063reckoner
reckons13269653reckons
recline94020493recline
recode93618713re_code
recon75624243re_con_
recons84922993re_cons
redan66125013red_an_
redans75421023red_ans
redate74124683red_ate
redbait1039803redbait
redbay1238333redb_ay
redbays1336013redbays
redbird1155263redbird
redbud10135803redb_ud
redbuds11144283redbuds
redbug10165473redb_ug
redbugs11134463redbugs
redcoat10410883redcoat
redden83613623redden_
reddened1136423reddened
reddens9259783reddens
redding103218513redding
reddle83815913red_dle
rede55037673red___e
redefine1238973redefine
redeny102712733red_eny
redeye103811793red_eye
redfin10310223redfin_
redfins1139923redfins
redhorse1245463redhorse
rediae74221993red_iae
reding83825563red_ing
redlined103811233redlined
redliner93510473redliner
redlines93916083redlines
redo56029363red_o__
redock134311543red_ock
redoes74623773red_oes
redoing93516733redoing
redonned10297103redonned
redos65126763red_o_s
redound968173redound
redout71820253red_out
redowa1038453red_owa
redox134714233red_o_x
redoxes15310883red_oxes
redpoll1045043redpoll
redrive112410563redrive
redroot8312903redroot
redtop937973redto_p
redtops1037373redtops
reduce9713253red_uce
redware1139363redware
redwing122811983redwing
redwood1236523redwood
redye94413473red__ye
reevoke14386363reevoke
refine95225693re_fine
refront10313263refront
refroze1956223refroze
region74614903region_
regions83613473regions
reline65434353re_line
remote84222603re_mote
remove116115573re_move
repine85627813re_pine
repose84121413re_pose
reprobe112310133reprobe
reprove122911073reprove
rerose63320843re_rose
rescore95616203rescore
reshine102816943reshine
reshoe92816483resho_e
resole64624183re_sole
respoke134311283respoke
respond1039113respond
response1037753response
restoke116113903restoke
restore75822983restore
retene69224273re_tene
retine66237333re_tine
retore67630773re_tore
retune69121953re_tune
revoke135216243re_voke
revote94917453re_vote
rewoke1339521223re_woke
rewon86920583re_won_
rewore938030163re_wore
rewove126420083re_wove
rewrote1039123rewrote
rexine134719443re_xine
rezoned173611163re_zoned
rezones163213943re_zones
ribbon1036533ribbon_
ribboned1343973ribboned
ribbons1136253ribbons
ribbony1443543ribbony
ribose839893r_ibose
ringbone1144953ringbone
seaborne1055433seaborne
trombone1245373trombone
undone7914253und_one
verbose1237753verbose

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.530337152.8
2DLD Change Limit1340271727.08018930.4
3Display Results1721720.0602866.7
 (SQL Overall)1786911727.67023297.4
 
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.