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

139 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
indicates1231258(None) 
indicate11313351indicate_
indicated13310951indicated
vindicates1646091vindicates
abdicates1448152abdicates
dedicates13311692dedicates
indagates1146572indagates
indicans1147662indica_ns
indicants1247202indicants
indicatives1745122indicatives
indicator1249012indicator
indicators1348612indicators
indices103513442indic__es
indicted1249202indic_ted
indictee1149622indic_tee
indictees1246162indictees
indicter1148142indic_ter
indicters1236732indic_ters
indicts103210722indic_t_s
indites83618982indi__tes
indurates10310692indurates
intimates111013312intimates
invocates1447642invocates
iodinates1048202iodinates
medicates14312112medicates
radicates12412072radicates
syndicates1644472syndicates
vindicate1546352vindicate_
vindicated1745122vindicated
abdicate1348903abdicate_
abdicated1547013abdicated
animates101316423an_imates
candidates1446303candidates
dedicate12312803dedicate_
dedicated14310253dedicated
dedicatee13410343dedicatee
dedicatees1445313dedicatees
delicates12314313delicates
dictates11311383__dictates
dilates83220663__dilates
educates1139623_educates
endites83717063endi__tes
endplates1246843endplates
eradicates1348263eradicates
ideates8313733i_d_eates
imbricates1645293imbricates
imitates10310503i_mitates
implicates1646783implicates
incages103013883in__cages
incases93615973in__cases
incites93218483in__cites
incubates1347603incubates
inculcates1446563inculcates
indagate1047193indagate_
indagated1245573indagated
indelicate1345933indelicate_
indican1048243indica__n
indicant11410343indica_nt
indicating1449693indicating
indication13312033indication
indications14310973indications
indicative1647713indicative
indicatory1646383indicatory
indicias1147413indic_ias
indiciums1453723indiciums
indict93115573indic_t__
indictor1147463indic_tor
indictors1247623indictors
indies73822783indi___es
indigenes11228993indigenes
indigoes10276783indi_goes
indite73520323indi__te_
indited93515023indi__ted
inditer83514233indi__ter
inditers93311053indi__ters
induces103611813induc__es
inducted1237273induc_ted
inductee1158053induc_tee
inductees1244713inductees
inducts10259573induc_t_s
indurate9311873indurate_
indurated1139013indurated
infinites1258693infinites
inflates11512193in_flates
ingates82716913in__gates
ingrates9514173in_grates
initiates9411183initiates
inmates92715783in__mates
innovates1245523innovates
inscapes1237813in_scapes
insinuates1045463insinuates
insolates9311273insolates
instates81615833in_states
instigates1148423instigates
insulates9311843insulates
intimate101013833intimate_
intimated121010893intimated
intimater111110583intimater
intimaters1297853intimaters
intonates9410243intonates
intoxicates2054443intoxicates
intricate11411193intricate_
intubates1147123intubates
inundates1045773inundates
invites103915813invi__tes
invocate1347833invocate_
invocated1546203invocated
iodates8312903iod__ates
iodinate949343iodinate_
iodinated1146943iodinated
irrigates1057253irrigates
irritates977223irritates
loricates11310123loricates
manducates1545593manducates
mediates112814063medi_ates
medicares1446873medicares
medicate13513243medicate_
medicated15410073medicated
meditates1239813meditates
nictates1039593_n_ictates
nidates8311893_n_idates
ordinates1049003ordinates
predicates15410823predicates
radiates92415293radi_ates
radicate11412873radicate_
radicated13410123radicated
redictates1348233redictates
silicates11311523silicates
sonicates11410383sonicates
suricates11311743suricates
syndicate1544513syndicate_
syndicated1743743syndicated
tunicates11268743tunicates
undulates1048923undulates
urticates1148893urticates
vesicates14119033vesicates
vindicator1644513vindicator
vindicators1744533vindicators
zincates1937743zin__cates

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411396.61022487.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.12625075.9
 
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.