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

120 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
arsenate8101048(None) 
arsenates979371arsenates
arsenite8119661arsenite
alienate8311552alienate
arenite71017712ar_enite
arsenal739382arsena_l
arsenals847752arsenals
arsenide9116332arsenide
arsenites9149162arsenites
crenate93317112cr_enate
senate63725172__senate
ablegate1147253ablegate
abnegate1144863abnegate
absence1137713absen_ce
absent84016993absen_t_
absented1156613absen_ted
absentee1067663absentee
absenter1086773absen_ter
absents93510723absen_ts
acerate92818913a_cerate
acetate92514753a_cetate
acierate10311813acierate
adnate72913483a__dnate
aerate64830553a__erate
agemate101210583a_gemate
agminate1139243agminate
agnate73314883a__gnate
alginate9310693alginate
alienage945583alienage
alienated1047743alienated
alienates9310683alienates
alternate948113alternate
ameerate1039633ameerate
ansate64517863ans__ate
antedate949693antedate
arcuate9311963ar_cuate
ardent73022613arden_t_
areae55229743ar_e_a_e
arena55323813ar_ena__
arenas65021993ar_ena_s
arene55329413ar_en__e
arenites8917103ar_enites
arenose7311373ar_enose
areolate81014453areolate
arete56031353ar_e__te
argent74023663argen_t_
argental947933argental
argentite1047813argentite
argents84014853argen_ts
arginase946443arginase
ariette7312373arie_tte
arillate8412993arillate
aristate8312133aristate
arpent84822093arpen_t_
arpents93613083arpen_ts
arrogate91210323arrogate
arsenic939323arsen_ic
arsenics1056763arsenics
arsenides1095613arsenides
arseno6318913arsen__o
arsenous847533arsenous
arsine64021043arsin__e
asperate10312373asperate
assent65119953assen_t_
assented957513assen_ted
assenter867703assen_ter
assents74512223assen_ts
attenuate974473attenuate
aureate72515283aure_ate
austenite945853austenite
carbonate13410513carbonate
carinate103320253car_inate
caseate9314783case_ate
caseinate1148243caseinate
casemate1239843casemate
catenate10312833catenate
create85126383cr_e_ate
cremate113816183cr_emate
crenated113013913cr_enated
enate54428153___enate
grenade938413gr_enade
insensate945393insensate
lisente71210703lisen_te
marginate12179603marginate
marinate103017783mar_inate
nauseate845893nause_ate
ordinate9310253ordinate
orientate946513orientate
ornate6315143or__nate
parsonage12225583parsonage
personate112111423personate
phenate12412203_phenate
predate10616893pr_edate
prelate9519693pr_elate
prename11412643pr_ename
pronate9418873pr_onate
racemate1239063racemate
rebate84424113_r_ebate
redate74124683_r_edate
relate64033633_r_elate
remate84428683_r_emate
rename82718813_r_ename
rente54733783_r_en_te
resinate8316773resinate
reslate73520593_reslate
resonate8513513resonate
restate73824883_restate
roseate7613453rose_ate
ruinate7312833_ruinate
sarsenet8412943sarsenet_
sarsenets946513sarsenets
sedate73019813__sedate
selenate81712533selenate
senates73322613__senates
sensate7311893__sensate
sente56432883__sen_te
serenate81914883serenate
urinate7315363ur_inate
variegate1344103variegate
venenate1147933venenate

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621207.61019206.6
3Display Results1201200.0462608.7
 (SQL Overall)1786911208.07922118.0
 
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.