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

146 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
depurate113998(None) 
depurated1338181depurated
depurates1239801depurates
deaerate9314162deaerate
decorate11315192decorate
denudate1046162denudate
depilate11311702depilate
deprave1337072dep_rave
depurator1247022depurator
depute94512302depu__te
derate74531232de__rate
desperate12410832desperate
despumate1443522despumate
separate10310782separate
accurate12410663accurate
adequate1844303adequ_ate
aerate64830553ae__rate
amputate1246263amputate
asperate10312373asperate
aspirate1039943aspirate
aurate64426473__aurate
berate84729023be__rate
cerate84829463ce__rate
cesurae937703cesura_e
copulate122614113copulate
cupulate122810033cupulate
curate85226243__curate
deaerated11311103deaerated
deaerates10313623deaerates
dealate83617843de_alate
debate94419193de__bate
debutante1243223debutante
decimate13411123decimate
decorated13312203decorated
decorates12314733decorates
decurve1335583decur_ve
decussate1243973decussate
dedicate12312803dedicate
defecate1438793defecate
deflate113613943de_flate
degrade10229903de_grade
dehydrate1744863dehydrate
delate73827753de__late
delegate10410463delegate
delicate11315493delicate
demarcate1446613demarcate
demure9311533demur__e
demurrage1342423demurrage
dendrite1048783dendrite
denervate1346173denervate
denigrate1168693denigrate
denitrate10810533denitrate
dentate8315153de_ntate
denudated1244933denudated
denudates1145583denudates
depart94720563depar_t_
departed1238823depar_ted
departee1139723departee
departs104310683depar_ts
depauperate1652063depauperate
depilated1339653depilated
depilates12310923depilates
deplane10311413dep_lane
deplete103010413dep_lete
depopulate1544413depopulate
deport94922393depor_t_
deported1249703depor_ted
deportee11510353deportee
deporter1169393depor_ter
deports105012883depor_ts
depraved1535543dep_raved
depraver1435413dep_raver
depraves1436873dep_raves
deprecate1477433deprecate
depredate1345723depredate
deprive1338303dep_rive
depurating1438643depurating
depurators1346473depurators
deputable1487033deputable
deputed114610173depu__ted
deputes104911783depu__tes
deputize2045423deputize
deputy12426713depu__ty
derat65044083de__rat_
derated93623503de__rated
derates84028883de__rates
derats74625063de__rats
derivate12311203derivate
derogate10311353derogate
desecrate1249073desecrate
desolate9411993desolate
despumated1643193despumated
despumates1543543despumates
detonate9311193detonate
deuterate1049503deuterate
deviate11312713de_viate
disparate1249053disparate
disrate81418523d_israte
educate10310213_educate
eluate62315433_elu_ate
emirate91015833_emirate
emulate9314123_emulate
ephorate1359503_ephorate
epilate9314283_epilate
equate152012463_equ_ate
expurgate1943823expurgate
exudate1537093_exudate
federate12310873federate
ferrate103014033fe_rrate
figurate1237183figurate
generate9312893generate
indurate9311873indurate
levirate1147623levirate
maturate10312613maturate
mercurate1347333mercurate
nephrite1346713nephrite
obdurate1175123obdurate
obturate1077773obturate
operate9615733_operate
peculate122414663peculate
perorate10417913perorate
pirate82322883__pirate
populate122812093populate
prate75135983__p_rate
pupate104213123__pupate
recrate92621643re_crate
recurvate1445853recurvate
regrate82618653re_grate
regulate9313023regulate
reoperate11410173reoperate
rephrase1346733rephrase
replate93420053rep_late
repudiate1246183repudiate
repursue1044033repursue
repute84716093repu__te
saturate8312813saturate
separated1237713separated
separates11310733separates
septate9511873sep_tate
serrate73017533se_rrate
suppurate1345433suppurate
temperate1348503temperate
tephrite1346593tephrite
uprate83916543_up_rate
urate55432163___urate
venerate11312893venerate

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.203880251.2
2DLD Change Limit1461621468.61016975.8
3Display Results1461460.0602433.3
 (SQL Overall)1786911468.87320138.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.