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

125 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
refrained134722(None) 
refrainer1245841refrainer
retrained10411311retrained
detrained1158912detrained
pretrained1357062pretrained
refined114720002ref__ined
refracted1557392refracted
refrain10310042refrain__
refrainers1344472refrainers
refrains1139592refrain_s
reframed1437852refra_med
refried113513882refr_i_ed
regained102111242re_gained
remained112412892re_mained
reordained1243442reordained
reraised9312362re_raised
restrained1148412restrained
retained93016092re_tained
retrainee9511162retrainee
befriend1443263befr_iend
befringed16123863befr_inged
brained103816103__brained
defined123813823def__ined
defragged1643043defragged
defrauded1542823defrauded
defrayed1635403defra_yed
deraigned1244093de_raigned
derailed102410403de_railed
destained1158253destained
detained103111643de_tained
drained93713253__drained
engrained1145493engrained
entrained1089413entrained
ermined10410603_e_rmined
grained93814273__grained
harebrained1752423harebrained
hebraized2443963hebraized
ingrained1145383ingrained
pertained1238503pertained
prefranked2042773prefranked
preordained1552823preordained
rained75024603___rained
reattained1144583reattained
reavailed1344003reavailed
rebaited11410543re_baited
recaned102817203re_ca_ned
reclaimed1435543reclaimed
reclined113613603re_clined
recoined113614433re_coined
recrated112918613recra_ted
recrowned1564863recrowned
recruited1236463recruited
redbaited1344713redbaited
redefined1445593redefined
redlined103811233re_dlined
redrafted1435143redrafted
redried93714903redr_i_ed
reearned948893re_earned
reexamined2052893reexamined
refaced133713573ref_a_ced
refiled114318653ref__iled
refind104717073ref__in_d
refine95225693ref__ine_
refiner105316913ref__iner
refines105426343ref__ines
refired115116993ref__ired
refixed183611153ref__ixed
reflagged1543093reflagged
reflated123514293refla_ted
refraining1437263refraining
refrainment1654483refrainment
reframe1239393refra_me_
reframes1338993refra_mes
reframing1538623reframin_g
refreshed1685623refreshed
refries104419733refr_i_es
refronted1336063refronted
refrying15278903refryin_g
regainer9249353re_gainer
regraded113410763regra_ded
regrafted1435243regrafted
regranted1137703regranted
regrated102816333regra_ted
regreened1145553regreened
regrind938983regr_in_d
reimagined1442893reimagined
reined74425523re___ined
rejoined16318593re_joined
relearned1035643relearned
relined85321933re__lined
reloaned939723reloa_ned
relumined1245363relumined
remailed112411403re_mailed
remanned11319353re_manned
renailed92512803re_nailed
reobtained1343393reobtained
repainted1277863re_painted
repaired1148953re_paired
repined104918773re__pined
replanned1235163replanned
repriced132610543repr_iced
reprinted1289043repr_inted
reprised112012213repr_ised
reracked15169123re_racked
reraise7316313re_raise_
reraises8415643re_raises
resailed93613063re_sailed
reshined123011123re_shined
resined84522653re__sined
restrainer1046973restrainer
retailed94113963re_tailed
retainer82913813re_tainer
retraced111413033retra_ced
retracked1657453retracked
retracted12410953retracted
retrain7615423retrain__
retrainees1046393retrainees
retrains8314533retrain_s
retried84419163retr_i_ed
rewrapped1763033rewrapped
sprained1138433_sprained
strained9412253_strained
trained84117203__trained
undrained1138523undrained
untrained10510993untrained

Search took 9 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 Filter1786911486410.436409841.7
2DLD Change Limit1486411257.56319653.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911258.04522211.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.