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

191 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
refrains113959(None) 
refrain10310041refrain_
retrains8314531retrains
detrains9411762detrains
pretrains11410142pretrains
refracts13137382refracts
refrained1347222refrained
refrainer1245842refrainer
refrainers1344472refrainers
reframes1338992reframes
reframing1538622reframing
refries104419732refr_ies
refrying15278902refrying
regains84316582re_gains
remains94117902re_mains
reordains10145452reordains
restrains9311622restrains
retains74522252re_tains
retrain7615422retrain_
terrains8410322terrains
bedrails1136293bedrails
berlins93216013be_rlins
brains85125473__brains
ceratins102818733ce_ratins
cremains1238693cre_mains
defrags1236193defra_gs
defrauds1343243defrauds
defraying1735853defraying
defrays1436113defra_ys
deraigns1034883de_raigns
derails84216393de_rails
destains9311813destains
detains83716093de_tains
detrain8412253detrain_
drains73719403__drains
elains64919853_e_lains
engrains937583engrains
entrains8312963entrains
forebrains1544623forebrains
frails93716473__frails
grains74223093__grains
heparins13310123heparins
heroins103518013he_roins
ingrains948983ingrains
jerkins18358253je_rkins
keratins122313483ke_ratins
merlins93015813me_rlins
murrains1036853murrains
pearmains1345263pearmains
pertains102113423pertains
prefrank1764233prefra_nk
prefranks1862993prefranks
preordains13124523preordains
pretrain10310923pretrain_
rains55140233___rains
reagins84215643re_agins
rearing83128783rear_ing
rearming111413613rearming
reattains946443reattains
reavails1134853reavails
rebaits9312573re_baits
rebegins1136003rebegins
reclaims1236113reclaims
recoins94019243re_coins
recrates102420373recrates
recrating121318793recrating
recrowns13246143recrowns
recruits1036563recruits
redans75421023re_da_ns
redbaits1135903redbaits
redfins1139923re_dfins
redrafts1235603redrafts
redrawing1437213redrawing
redrawn11245953redrawn_
redraws11218473redra_ws
redries83721713redr_ies
redrying13209023redrying
redskins1385873redskins
redtails968003redtails
reearns749103re_earns
refaces123216743ref_aces
refacing142512813refacing
refalls103312243ref_alls
referring1338033referring
reffing143712173ref_fing
refiling123116533refiling
refind104717073ref__ind
refinds114512123ref__inds
refine95225693ref__ine
refines105426343ref__ines
refining122416863refining
refiring123513923refiring
refits94017653ref__its
refixing19329793refixing
reflags1156953refla_gs
reflates113115663reflates
reflating132514713reflating
reflations13311233reflations
reflies104418533ref_lies
reflying15268173reflying
reforging1437663reforging
reforming1538563reforming
refract121311603refra_ct
refracting1638733refracting
refractions16127723refractions
refraining1437263refraining
reframe1239393refra_me
reframed1437853reframed
refried113513873refr_ied
refront10313263refr_ont
refronts1137773refronts
refuging13218423refuging
refusing122310873refusing
refuting121911903refuting
regain74517763re_gain_
regrades103212173regrades
regrading121210203regrading
regrafts1235303regrafts
regrant8317323regra_nt
regrants9310013regrants
regrates92618403regrates
regrating111316213regrating
regreens9257453regreens
regrind938983regr_ind
regrinds1035533regr_inds
reins56234563re___ins
rejoins143111383re_joins
relaxins15248683relaxins
relearns836303relearns
reloans7313133reloa_ns
remails94714563re_mails
remain85919863re_main_
remans84823003re_ma_ns
renails74917263re_nails
renins64526453re__nins
rennins74013413re_nnins
reobtains1144433reobtains
reordain9135573reordain_
repaint9318363re_paint
repaints1038483re_paints
repairs9319973re_pairs
repins84924313re__pins
replans92814943repla_ns
reprint9318983repr_int
reprints1039903repr_ints
requins16310203re_quins
reracks132310533re_racks
reraise7316313re_raise
reraises8415643re_raises
reran57329103re_ra_n_
rerigs74014793re_r_igs
reruns66413743re_r_uns
resails74616743re_sails
resilins83013373resilins
resins64528773re__sins
resorcins1146983resorcins
restrain8311703restrain_
restraint9412753restraint
restraints1056603restraints
retails74718973re_tails
retain64523283re_tain_
retraces101417273retraces
retracing12313293retracing
retracks14149103retracks
retracts101111313retracts
retrained10411313retrained
retrainee9511163retrainee
retrainees1046393retrainees
retrials8510823retrials
retries74129073retr_ies
retrims93612373retr_ims
retrying122410453retrying
rewins95020823re__wins
rewraps12136563rewra_ps
ruffians1443793ruffians
safranins1244353safranins
seatrains947603seatrains
serails73318363se_rails
serais64326133se_rai_s
sereins73716113se_reins
serins64029673se_r_ins
sextains15246813sextains
sprains93013593_sprains
strains74218153_strains
terais64023513te_rai_s
terrain7410853terrain_
terrapins1146183terrapins
trains64725343__trains
verdins112812333ve_rdins
vervains1435293vervains
vitrains1138283vitrains

Search took 10 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621918.97016294.5
3Display Results1911910.1561224.4
 (SQL Overall)1786911919.27919257.6
 
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.