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

111 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
reynard113512(None) 
reynards1244301reynards
keycard1743662keycard
reboard10310762reboard
regard85215772re_gard
reheard11309022reheard
retard75018932re_tard
reward106017642re_ward
bayard124411663bay_ard
beard86024963be__ard
bedward1497473bedward
beeyard1335523beeyard
boyard125411283boy_ard
canard9314763_canard
debeard1137353debeard
denar65223293de_nar_
denari710917353de_nari
denars74621433de_nars
denary105316863de_nary
echard1249223_echard
foreyard1546423forey_ard
gurnard944773gurnard
hayward1736413hayward
heard95222753he__ard
hennaed1135103hennaed
jeopard1744113jeopard
keyboard1844503keyboard
keycards1843063keycards
keypad1633823keypa_d
keyword1844563keyword
lanyard1167293lanyard
leeward1135783leeward
leopard1045293leopard
leotard846193leotard
lyard95113213_ly_ard
menad85918983me_na_d
nard56634453___nard
petard95013803pe_tard
preboard1338263preboard
read55942533re__a_d
readd74617133re__add
rear45644553re__ar_
reared75930013re__ared
rearm75923573re__arm
rears54739653re__ars
rearward1245783rearward
rebar75420193re_bar_
rebars84019833re_bars
reboards1138773reboards
recaned102817203recaned
rechart12314333rechart
reclad9311873recla_d
record96117433re_cord
redbird1155263redbird
redear73515173redear_
redears82814453redears
redware1139363redware
reearn6612143re_earn
reenact9413013reenact
reentry1038033reentry
regards94112563re_gards
regear73512743regear_
regeared1039433regeared
regears83012463regears
regna64614813regna__
regnal74812933regna_l
regnant8312843regnant
rehear93713223rehear_
rehears103312773rehears
reined74425523rein_ed
reinked1239793reinked
relaid75518443re_laid
reland75920433re_land
relearn747973relearn
reload7413893reloa_d
remand95618963re_mand
remark123512373re_mark
remnant9312643remnant
renail65020763re_nail
renal55929503re_na_l
rename82718813re_name
renamed103114523re_named
rend56136573re_n__d
rended84524103re_nded
rennase738713rennase
rented74426593re_nted
repaid94716323re_paid
repand95316063re_pand
repark123511713re_park
reread71715433rerea_d
rereward1246143rereward
resaid74517083re_said
restart7320033restart
retards85015003re_tards
retear63115483retear_
retears72814923retears
retiary1038333retiary
rewards114813993re_wards
rewarm115913493re_warm
rewear93012003rewear_
rewears102911043rewears
reword106321413re_word
ritard74812083r_itard
rynd86414103r_yn__d
seaward1148183seaward
senary93716073se_nary
skyward1843863skyward
tanyard1167183tanyard
ternary1038343ternary
wayward1736053wayward
yard85633253__y_ard

Search took 7 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.420425454.8
2DLD Change Limit1340271116.29621287.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.76226425.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.