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

226 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
agitate831206(None) 
agitated1038411agitated
agitates9310881agitates
agitato856571agitato
acetate92514752acetate
agate66525152ag__ate
agemate101210582agemate
agiotage1043562agiotage
agita6315422agita__
agitable1138582agitable
agitas7310592agita_s
agitative1346872agitative
agitator946712agitator
agminate1139242agminate
agnate73314882ag_nate
alginate9310692alginate
amirate91115952amirate
animate91617212animate
aristate8312132aristate
aviate9315202avi_ate
capitate121712182capitate
cavitate13159832cavitate
cogitate1148552cogitate
digitate1098682digitate
imitate9310872imitate
paginate114012442paginate
sagittate1043602sagittate
sanitate8612042sanitate
vaginate123911082vaginate
abate76627843a__bate
abdicate1348903abdicate
ablate82219213a_blate
acerate92818913acerate
acetated112010683acetated
acetates102013063acetates
acierate10311813acierate
activate13510373activate
actuate9311443actuate
acuate8315633a_cuate
acylate12310533acylate
adnate72913483a_dnate
adulate8313233adulate
aerate64830553a_erate
agamete1037403agamete
agapae9388043agapa_e
agape85614843ag__ape
agates76121343ag__ates
agatize1739833agatize
agave95314033ag__ave
agaze156113663ag__aze
agemates111110023agemates
aggrade1035643aggrade
agile65122263agi__le
agility1148653agility
agiotages1143773agiotages
agist66325583agi_st_
agisted938203agi_sted
agists75713173agi_sts
agitatedly1552123agitatedly
agitating1138863agitating
agitation10311223agitation
agitators1046623agitators
aglare7312433ag_lare
aglitter935093aglit_ter
agnates82813193ag_nates
agorae7511203agora_e
agrafe1038093ag_rafe
aguacate1144973aguacate
airdate8311323airdate
alate55340333a__late
alginates10310123alginates
alidade936993alidade
alienate8311553alienate
aliterate91611343aliterate
amidase1036733amidase
amirates101114793amirates
amputate1246263amputate
anatase738943anatase
angulate9312013angulate
animated111612373animated
animater101512393animater
animates101316423animates
animato91610623animato
annotate877713annotate
ansate64517863a_nsate
antae56828293a_nta_e
antistate9410143antistate
aortae65115473aorta_e
apatite9312963apatite
apostate1049853apostate
arbitrate11137373arbitrate
arcuate9311963arcuate
arginase946443arginase
ariette7312373ariette
arillate8412993arillate
aristae7312533arista_e
artiste73813693artiste
aspirate1039943aspirate
astute6310763a_stute
augite7312613augi__te
aurate64426473a_urate
aureate72515283aureate
aviated11310263avi_ated
aviates10313063avi_ates
axite125218253axi__te
binate8419773_binate
bistate9313823bistate
califate13310483califate
capitated14159043capitated
carinate103320253carinate
cavitated15177353cavitated
cavitates14168963cavitates
citrate92216803_citrate
climate11312833climate
cogitated1346323cogitated
cogitates1247863cogitates
costate94019273costate
cristate10310603cristate
curtate9312643curtate
dentate8315153dentate
dictate10311663dictate
digitated1286963digitated
dilate73220693_dilate
emirate91015833emirate
epilate9314283epilate
estate64719763_estate
evaginate1376483evaginate
fixate1638733_fixate
frigate11311063frigate
galeate83916793galeate
gallate83417133gallate
gate55746573_g__ate
gelate73421263_gelate
gestate83614073gestate
gitano738043_gitano
gite55438613_gi__te
gitted84015053_git_ted
grate64932883_g_rate
gravitate1345543gravitate
guttae73210583_guttae
guttate8328903guttate
gyrate104912523_gyrate
habitat12411053habitat_
habitats1346733habitats
habituate1443923habituate
hastate10313913hastate
hesitate1169973hesitate
imitated1138263imitated
imitates10310503imitates
initiate8412693initiate
instate71616483instate
irate55627983__irate
irritate867873irritate
kalifate1556493kalifate
labiate91313573labi_ate
lactate9312703lactate
laminate103014633laminate
lapidate1157903lapidate
levitate1137933levitate
ligate72519253_ligate
magistrate1344073magistrate
magnate10512703mag_nate
marginate12179603marginate
marinate103017783marinate
meditate11310623meditate
metate82720533_metate
migrate101314173migrate
militate10311673militate
misate81222693_misate
mutate83017483_mutate
navigate1246073navigate
nictate9310223nictate
nidate7313783_nidate
nitrate72017013_nitrate
notate63217863_notate
nutate63017373_nutate
opiate8513463opi_ate
outate62923403_outate
oxidate1537023oxidate
paginated13309463paginated
paginates123111363paginates
palmitate1346413palmitate
palpitate1365973palpitate
patinate103016313patinate
pectate112214693pectate
peltate92013773peltate
pirate82322883_pirate
plicate11314513plicate
primate111516283primate
private121513263private
quinate16511573quinate
radiate83416313radi_ate
radicate11412873radicate
restate73824883restate
rotate63320343_rotate
ruinate7312833ruinate
sagittal943283sagittal
salivate11310013salivate
sanitated1068993sanitated
sanitates9611733sanitates
satiate7315403sati_ate
scutate9310323scutate
septate9511873septate
shitake1455623shitake
sigmate10710143sigmate
situate7410783_situate
spicate113214193spicate
spinate93114813spinate
state56237333__state
tate44748603___tate
testate73916233testate
titrate72215573_titrate
tristate8311033tristate
unitage838993unitage
unstate71916213unstate
upstate91610493upstate
urinate7315363urinate
vaginae11377683vagina_e
vaginated14328153vaginated
validate1239003validate
variate101316433vari_ate
vegetate1246673vegetate
vitae84217633_vita_e
vitiate103412953_vitiate
vittae93911003_vittae
vittate10409733vittate

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272266.64020184.8
3Display Results2262260.0802825.0
 (SQL Overall)1786912267.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.