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

147 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
relearns83630(None) 
reearns749101re_earns
relearn747971relearn_
relearnt849211relearnt
learns65513742__learns
recleans1037512reclea_ns
redears82814452redear_s
reearn6612142re_earn_
regears83012462regear_s
rehears103312772rehear_s
relearned1035642relearned
releases8313342releases
reloans7313132reloa_ns
retears72814922retear_s
rewears102911042rewear_s
telerans859472telerans
unlearns844452unlearns
beleaps1138053belea_ps
bemeans1148743bemea_ns
blears85116453_blear_s
cellars93713693cellar_s
cleans85817053_clea_ns
clears84116563_clear_s
debeards1235503debeards
decerns10119053dece_rns
deleads9379703delea_ds
deleaves1248063deleaves
demeans1039723demea_ns
earns55927563___earns
elains64919853_el_ains
elans55527753_el_a_ns
elevens1066803_elevens
elevons1067573_elevons
gleans75014743_glea_ns
goldarns1043593goldarns
leans55536253__lea_ns
learn55322663__learn_
learnt64019253__learnt
lears55938733__lear_s
mislearns1144523mislearns
outearns838403outearns
outlearns944633outlearns
overlearns1344993overlearns
precleans1344893preclea_ns
preclears1344373preclear_s
prewarns13456943pre_warns
readorns938283readorns
realgars934533realgar_s
rearms85114653r__earms
rears54739653r__ear_s
rebars84019833re_bar_s
rebegins1136003rebegins
reboards1138773reboards
recharts1337663recharts
reclean938523reclea_n_
redans75421023re_da_ns
redear73515173redear__
redwares1239053redwares
reearned948893re_earned
reelers73520273reeler_s
refers93921083refe_r_s
refrains1139593refrains
regains84316583re_gains
regards94112563re_gards
regear73512743regear__
regeared1039433regeared
regearing112211413regearing
rehear93713223rehear__
reheard11309023rehear_d
rehearing132211763rehearing
rehearings14214573rehearings
rehearse11296663rehearse
rehearses12286853rehearses
reheats104513533rehea_ts
relaces93420883rel_aces
reland75920433rel_a_nd
relands85214883rel_ands
relates73731443rel_ates
relaxes143215323rel_axes
relaxins15248683relaxins
relays94316753rel_a_ys
relearning1135283relearning
release7312763relea_se
released9310243released
releaser839503releaser
releasers937323releasers
releasing10411013releasing
relegates10310943relegates
relend76116453rele__nd
relends84013253rele_nds
relent64431853rele__nt
relents74018503rele_nts
relets64025673rele__ts
relevant1149243relevant
releves103914973rele_ves
reliant7319243relia_nt
reliers75519213relier_s
reloads8911313reloa_ds
reloan6415693reloa_n_
remains94117913re_mains
remans84823003re_ma_ns
remarks13329983re_marks
reparks13249513re_parks
repeals94014533repea_ls
repeats94316063repea_ts
reperks13298093repe_rks
replans92814943repla_ns
repleads11357213replea_ds
replevins1465203replevins
rereads81512293rerea_ds
rerewards1344643rerewards
reseals73917683resea_ls
research1344553research
reseasons944873reseasons
reseats74319593resea_ts
reseaus74012153resea_us
restarts8310873restarts
retains74522253re_tains
retards85015003re_tards
reteams9339563retea_ms
retear63115483retear__
retearing102214253retearing
retrains8314533retrains
returns79712593re_turns
reveals103812743revea_ls
reverbs12368863reve_rbs
reveres103621343reve_res
revers94529633reve_r_s
reverts104715053reve_rts
rewards114813993re_wards
rewarms12439603re_warms
rewear93012003rewear__
rewearing132310703rewearing
reweaves1436603reweaves
reynards1244303reynards
rezeros1647453reze_ros
rulers64317093rule_r_s
secerns987733sece_rns
telemarks1543663telemarks
teleran7510183teleran_
treelawns1242053treelawns
unlearn735953unlearn_
unlearnt846403unlearnt
velars93913723vel_ar_s
veterans1148853veterans
welfares1445553welfares
yearns9509543__yearns

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.436409841.7
2DLD Change Limit1461621479.12616016.0
3Display Results1471470.0602450.0
 (SQL Overall)1786911479.62218571.1
 
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.