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

204 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
refrain1031004(None) 
refrains1139591refrains
retrain7615421retrain
detrain8412252detrain
pretrain10310922pretrain
redrawn11245952redrawn
refract121311602refract
refrained1347222refrained
refrainer1245842refrainer
reframe1239392reframe
reframing1538622reframing
refrying15278902refrying
regain74517762re_gain
remain85919862re_main
reordain9135572reordain
reran57329102re_ra_n
restrain8311702restrain
retain64523282re_tain
retrains8314532retrains
terrain7410852terrain
afraid1049723_afraid
bedrail1037253bedrail
berlin83116373be_rlin
brain76229383__brain
ceratin93020163ce_ratin
certain92612213certain
defrag1136463defra_g
defrags1236193defrags
defraud1243913defraud
defray1337643defra_y
defraying1735853defraying
defrays1436113defrays
deraign936573de_raign
derail74218813de_rail
destain8412083destain
detain74617383de_tain
detrains9411763detrains
drain65222893__drain
elain55324703_e_lain
engrain838353engrain
entrain7313073entrain
fain75840563__f_ain
forebrain1445163forebrain
frail85220213__frail
grain65126253__grain
heparin12410433heparin
herein93717793he_rein
heroin94420593he_roin
ingrain839523ingrain
jerkin17258113je_rkin
keratin113314153ke_ratin
merlin83916683me_rlin
murrain937763murrain
pearmain1245833pearmain
pertain92714963pertain
prefrank1764233prefrank
preordain12124493preordain
pretrains11410143pretrains
rain46251733___rain
reagin74915533re_agin
rearing83128783rear_ing
rearming111413613rearming
reattain846733reattain
reavail1035643reavail
rebait8320403re_bait
rebegin1036213rebegin
reclaim1137753reclaim
recoin84320293re_coin
recrate92621663recrate
recrating121318793recrating
recrown12257573recrown
recruit939773recruit
redan66125013re_da_n
redbait1039803redbait
redfin10310223re_dfin
redraft11310573redraft
redraw10269853redra_w
redrawing1437213redrawing
redraws11218473redraws
redrying13209023redrying
redskin1286023redskin
redtail858713redtail
reearn6612143re_earn
reface113616353ref_ace
refacing142512813refacing
refall94314393ref_all
referring1338033referring
reffing143712173ref_fing
refiling123116533refiling
refind104717073ref__ind
refine95225693ref__ine
refining122416863refining
refiring123513923refiring
refit84230063ref__it
refix155212483ref__ix
refixing19329793refixing
reflag1098083refla_g
reflags1156953reflags
reflate103516263reflate
reflating132514713reflating
reflation12412333reflation
reflown13316213reflown
reflying15268173reflying
reforging1437663reforging
reforming1538563reforming
refracting1638733refracting
refraction15137903refraction
refracts13137383refracts
refrainers1344473refrainers
refraining1437263refraining
reframed1437853reframed
reframes1338993reframes
refresh1335453refresh
refried113513873refried
refries104419733refries
refront10313263refront
refroze1956223refroze
refrozen2063873refrozen
refry114412463refr__y
refugia1144313refugia
refuging13218423refuging
refusing122310873refusing
refuting121911903refuting
regains84316583re_gains
regrade92612033regrade
regrading121210203regrading
regraft11310153regraft
regrant8317323regrant
regrate82618663regrate
regrating111316213regrating
regreen8309043regreen
regrind938983regr_ind
regrown11237363regrown
rein46040893re___in
rejoin134012243re_join
relaid75518443re_laid
relaxin14239183relaxin
relearn747973relearn
reloan6415693reloa_n
remail85017123re_mail
remains94117913re_mains
reman75730153re_ma_n
renail65020763re_nail
renin54830033re__nin
rennin63914033re_nnin
reobtain1044623reobtain
reordains10145453reordains
repaid94716323re_paid
repaint9318363re_paint
repair84011463re_pair
repin75324703re__pin
replan83215823repla_n
reprint9318983repr_int
requin15310713re_quin
rerack122513163re_rack
reraise7316313re_raise
rerig64018483re_r_ig
rerun58722153re_r_un
resaid74517083re_said
resail64418733re_sail
resawn9399953re_sawn
resilin72913973resilin
resin54131053re__sin
resorcin1046823resorcin
restrains9311623restrains
restraint9412753restraint
retail65522073re_tail
retains74522253re_tains
retrace91417343retrace
retracing12313293retracing
retrack131310723retrack
retract91318113retract
retrained10411313retrained
retrainee9511163retrainee
retral64419743retra_l
retrial7615553retrial
retrim83514883retr_im
retrying122410453retrying
rewan85623663re_wa_n
rewin85623963re__win
rewrap11127533rewra_p
rewraps12136563rewraps
rewrapt12138113rewrapt
ruffian1344133ruffian
safranin1145213safranin
seatrain847923seatrain
serai56830163se_rai_
serail64222673se_rail
serais64326133se_rais
serein63318463se_rein
serin55434443se_r_in
sextain14257103sextain
sprain83614863_sprain
strain64919573_strain
terai53525483te_rai_
terais64023513te_rais
terrains8410323terrains
terrapin1046203terrapin
train56529113__train
verdin103113023ve_rdin
vermin113414523ve_rmin
vervain1335563vervain
vitrain1038943vitrain
zebraic2044293zebraic

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.406440125.6
2DLD Change Limit1340272046.67020094.0
3Display Results2042040.0802550.0
 (SQL Overall)1786912047.15624970.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.