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

152 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
indicate1131335(None) 
indicated13310951indicated
indicates12312581indicates
vindicate1546351vindicate
abdicate1348902abdicate
dedicate12312802dedicate
indagate1047192indagate
indelicate1345932indelicate
indican1048242indica_n
indicans1147662indicans
indicant11410342indicant
indicants1247202indicants
indicative1647712indicative
indicator1249012indicator
indict93115572indic_t_
indicted1249202indic_ted
indictee1149622indictee
indicter1148142indic_ter
indicts103210722indic_ts
indite73520322indi__te
indurate9311872indurate
intimate101013832intimate
intricate11411192intricate
invocate1347832invocate
iodinate949342iodinate
medicate13513242medicate
radicate11412872radicate
syndicate1544512syndicate
vindicated1745122vindicated
vindicates1646092vindicates
abdicated1547013abdicated
abdicates1448153abdicates
animate91617213an_imate
candidate1356663candidate
dedicated14310253dedicated
dedicatee13410343dedicatee
dedicates13311693dedicates
delicate11315493delicate
dictate10311663__dictate
dilate73220693__dilate
educate10310213_educate
endite73817593endi__te
endplate1147083endplate
eradicate1259183eradicate
ideate7313683i_d_eate
imbricate1545663imbricate
imitate9310873i_mitate
implicate1547273implicate
inanimate1146993inanimate
incage93513623in__cage
incase83615283in__case
inchoate1347673inchoate
incite83618733in__cite
increate10312203increate
incubate1238663incubate
incudate1138873incudate
inculcate1347433inculcate
indagated1245573indagated
indagates1146573indagates
indicating1449693indicating
indication13312033indication
indicatives1745123indicatives
indicators1348613indicators
indicatory1646383indicatory
indices103513443indic_es
indicia1046983indic_ia
indicias1147413indicias
indicium1355293indicium
indictable1547493indictable
indictees1246163indictees
indicters1236733indic_ters
indictor1147463indictor
indie63721473indi___e
indigene10298603indigene
indited93515023indi__ted
inditer83514233indi__ter
indites83618983indi__tes
indocile1146703indocile
induce93811533induc__e
induct93212743induc_t_
inducted1237273induc_ted
inductee1158053inductee
inducts10259573induc_ts
indurated1139013indurated
indurates10310693indurates
indusiate1046403indusiate
infinite1149593infinite
inflate10312313in_flate
infuscate1444333infuscate
ingate73018243in__gate
ingrate8715123in_grate
initiate8412693initiate
inmate82917363in__mate
innate63917313in__nate
innovate1145643innovate
inordinate1145943inordinate
inscape1138013in_scape
insinuate945963insinuate
insolate8311893insolate
instate71616483in_state
instigate1048613instigate
insulate8312843insulate
intimae9109753intima_e
intimated121010893intimated
intimater111110583intimater
intimates111013313intimates
intonate8310923intonate
intoxicate1955003intoxicate
intubate1047533intubate
inundate946043inundate
inviolate1246393inviolate
invite93715033invi__te
invocated1546203invocated
invocates1447643invocates
iodate7313503iod__ate
iodinated1146943iodinated
iodinates1048203iodinates
irrigate967633irrigate
irritate867873irritate
loricate10310663loricate
manducate1445773manducate
mediate103415213medi_ate
medicare1347483medicare
medicated15410073medicated
medicates14312113medicates
meditate11310623meditate
muricate12311113muricate
nictate9310223_n_ictate
nidate7313783_n_idate
ordinate9310253ordinate
plicate11314513_plicate
predicate14411783predicate
radiate83416313radi_ate
radicated13410123radicated
radicates12412073radicates
redictate1249063redictate
silicate10312623silicate
sonicate10310933sonicate
spicate113214193_spicate
suricate10312613suricate
syndicated1743743syndicated
syndicates1644473syndicates
tunicate103310043tunicate
uncinate10312393uncinate
underate9918603underate
undulate9310403undulate
urticate1049863urticate
vesicate131210053vesicate
vindicable1843903vindicable
vindicative2053793vindicative
vindicator1644513vindicator
zincate1838533zin__cate

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621526.94021060.8
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.40924118.1
 
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.